Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting at access data from vfp9 = windows 8.1
Message
From
13/08/2014 08:21:03
 
 
To
11/08/2014 07:59:07
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01605427
Message ID:
01605548
Views:
61
>
>lcSourcefile = 'D:\DATA\Yourtable.ACCDB'
>lnConnHandle = SQLSTRINGCONNECT("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + lcSourceFile)
>
Tore,
as always, you are the man
Thanks
I had in the meantime gone the hard way through export to excel and then in vfp import
fortunately there are only 6 table involved

Peter
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform