Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Doug_Bak
Starting Member
9 Posts |
 Posted - 2004-06-30 : 14:25:22
|
| Remote Server: Win2K with Foxpro 6.0 - in DelawareLocal Server: SQL 2000 3a - in FloridaBoth servers are members of the same domain, connectedvia frame.Configured ODBC for FreeTable directory to access .dbf files.Configured SQL Linked Server Problem: All the tables are not shown in the available list of tables. I have tried using SQL Server, Access, Microsoft Query (out of Office) all with no success. I can query the tables that show up in the list of tables available in the Linked Server. Unfortunately, I need to access 3 tables that do not show up in the list, yet physically reside in the directory specified.Side note: I do have access to link to the tables in an Access 2000 database when it resides on the Foxpro server, but when I create a query to access the data, and create a linked server to the Access database, errors are returned. Unfortunately, Access can not be scheduled to extract data. This will be an ongoing weekly data extract, and it would be nice to schedule a DTS task to do this. |
|
|
|
|
|
Foxpro to SQL Import problem