Hi all,
I have Visual Foxpro 6.0 tables on network server inside a foxpro
database container .dbc. I have SQL server 7.0 on another server on the
network. I want to import the dbf files of foxpro into SQL server.
Can anybody suggest a way to do it. I created a linked server by giving the
path but I get the ODBC driver error as it cannot open the .dbc file.
Any suggestions?
Message posted via http://www.sqlmonster.com
Try DTS - you should be able to import the data that way assuming you have
the proper data driver for Foxpro
I have a visual foxpro driver in my list, but I'm not sure what version it
is.
"rameshwar elka via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a37fe497729140acbd10a8e569c94622@.SQLMonster.c om...
> Hi all,
> I have Visual Foxpro 6.0 tables on network server inside a foxpro
> database container .dbc. I have SQL server 7.0 on another server on the
> network. I want to import the dbf files of foxpro into SQL server.
> Can anybody suggest a way to do it. I created a linked server by giving
the
> path but I get the ODBC driver error as it cannot open the .dbc file.
> Any suggestions?
> --
> Message posted via http://www.sqlmonster.com
Showing posts with label foxprodatabase. Show all posts
Showing posts with label foxprodatabase. Show all posts
Wednesday, March 7, 2012
server to Visual Foxpro .dbc database on network from sql server
Hi all,
I have Visual Foxpro 6.0 tables on network server inside a foxpro
database container .dbc. I have SQL server 7.0 on another server on the
network. I want to import the dbf files of foxpro into SQL server.
Can anybody suggest a way to do it. I created a linked server by giving the
path but I get the ODBC driver error as it cannot open the .dbc file.
Any suggestions?
Message posted via http://www.droptable.comTry DTS - you should be able to import the data that way assuming you have
the proper data driver for Foxpro
I have a visual foxpro driver in my list, but I'm not sure what version it
is.
"rameshwar elka via droptable.com" <forum@.droptable.com> wrote in message
news:a37fe497729140acbd10a8e569c94622@.SQ
droptable.com...
> Hi all,
> I have Visual Foxpro 6.0 tables on network server inside a foxpro
> database container .dbc. I have SQL server 7.0 on another server on the
> network. I want to import the dbf files of foxpro into SQL server.
> Can anybody suggest a way to do it. I created a linked server by giving
the
> path but I get the ODBC driver error as it cannot open the .dbc file.
> Any suggestions?
> --
> Message posted via http://www.droptable.com
I have Visual Foxpro 6.0 tables on network server inside a foxpro
database container .dbc. I have SQL server 7.0 on another server on the
network. I want to import the dbf files of foxpro into SQL server.
Can anybody suggest a way to do it. I created a linked server by giving the
path but I get the ODBC driver error as it cannot open the .dbc file.
Any suggestions?
Message posted via http://www.droptable.comTry DTS - you should be able to import the data that way assuming you have
the proper data driver for Foxpro
I have a visual foxpro driver in my list, but I'm not sure what version it
is.
"rameshwar elka via droptable.com" <forum@.droptable.com> wrote in message
news:a37fe497729140acbd10a8e569c94622@.SQ
droptable.com...
> Hi all,
> I have Visual Foxpro 6.0 tables on network server inside a foxpro
> database container .dbc. I have SQL server 7.0 on another server on the
> network. I want to import the dbf files of foxpro into SQL server.
> Can anybody suggest a way to do it. I created a linked server by giving
the
> path but I get the ODBC driver error as it cannot open the .dbc file.
> Any suggestions?
> --
> Message posted via http://www.droptable.com
Subscribe to:
Posts (Atom)