Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting data from MDB to SQL 2000
Message
From
26/09/2005 05:10:55
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
 
To
26/09/2005 04:53:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01052928
Message ID:
01052943
Views:
8
I dont know what you are trying to do, is this an operation that needs to carried out more than once, if so look at hooking in the MDB as a linked server this will allow you to access it more easily than the OPENROWSET. If the Openrowset doesnt work directly look at puttin it into an SQL SP to and then call that.

Also you could look at ADO, something like..
loconnection = createobject("adodb.connection")
loconnection.open("DBQ=g:\products\ppwin\dev32\data\test2.mdb;DefaultDir=g:\products\ppwin\dev32\data\test2.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;PWD=619238")


>Hi Jon,
>
>I've tried the OPENROWSET of SQL and it worked!... I tried it in query analyzer but could'nt make it work in vfp.
>
>I've tried using sqlexec but won't work. Please help...
>
>Thanks in advance...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform