Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extracting data from MDB to SQL 2000
Message
De
26/09/2005 05:10:55
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
 
 
À
26/09/2005 04:53:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01052928
Message ID:
01052943
Vues:
10
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...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform