February 12, 2009 at 9:31 am
When I use the DBase drivers to import this I get an error stating that :
Microsoft Jet Database Engine
External tables not in expected format
Context: error set OpenRowSet on Provider ....
I get this on the Dbase 3,4, and 5 drivers.....
I have tried the Visual Foxpro OLE DB driver but when I get to the point where I need to pick the source and the destination nothing shows on the screen...
Ravi
February 12, 2009 at 9:50 am
raviq123 (2/12/2009)
I have tried the Visual Foxpro OLE DB driver but when I get to the point where I need to pick the source and the destination nothing shows on the screen...Ravi
ON what screen? Are these FoxPro free tables or a FoxPro database?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 12, 2009 at 12:51 pm
I was trying sql server 2000 import/export data utility and getting those messages. They are not free foxpro table, they are real table and some of those table can be imported without problem but not all, don't know.
February 12, 2009 at 12:55 pm
What do you mean "real tables"
Are these created with a VFP application?
February 13, 2009 at 7:40 am
What do you mean "real tables"
real table means table created by dba or user.
Are these created with a VFP application?
Yes, these are created with Visual Fox Pro application.
February 13, 2009 at 8:56 am
U can download the driver from here and install it on ur system and while importing it to sql server u need to select that driver..
Download & Install "Microsoft OLE DB Provider for Visual FoxPro 9.0" from...
Hope this helps.
Thanks,
Karen
February 13, 2009 at 9:46 am
raviq123 (2/12/2009)
I was trying sql server 2000 import/export data utility and getting those messages. They are not free foxpro table, they are real table and some of those table can be imported without problem but not all, don't know.
Let me explain a little more. For many years FoxPro only had tables without a method for creating relationships like Oracle, SQL Server, and Access had, then, I think sometime around VFP 6, databases were added which allowed you to directly create relationships, these files are .dbc files and they function more like a true database. So tables that have no related .dbc are called Free Tables.
If you are working with a FoxPro database (.dbc) then the steps will be different than those for working with Free Tables.
I have succesfully imported an entire FoxPro application's data structure (free tables) using the import/export wizard.
Attached is a Word Doc with screen shots.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply