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 |
|
mbailey
Starting Member
1 Post |
 Posted - 2008-11-21 : 12:11:07
|
| I'm trying to figure out how to create a SQL table by "linking" it to a VFP table. Some suggested this as a solution to a problem we're having trying to get the application KnowledgeSync (KS) to connect to our accounting application. KS uses ODBC and the most recent VFP ODBC driver is for version 6 and our tables are version 9. They're using some data types that the ver 6 driver doesn't support. So, the suggestion was to create some kind of "linked" table in SQL Server, and then connect KS to the SQL server table.I have no SQL Server experience, but have downloaded and installed SQL Server Express. I can't even figure out how to access this external table within SQL Server.Does anyone have any suggestions? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-21 : 12:15:47
|
| either add it as a linked server to your sql server and useselect * INTO YourNewTable FROM VFPserver.db.schema.tablenameor use OPENROWSEThttp://msdn.microsoft.com/en-us/library/ms190312(SQL.90).aspx |
 |
|
|
|
|
|
How to create a SQL table by linking it to a VFP t