Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement