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