>Hi all,
>
>I need to import the contents of an Access table into an existing FoxPro table. What is the best way to do this? I'm new to FoxPro so don't know much about setting up ODBC links - are there any good examples out there?
>
>Thanks
An example how to connect to Access DB and get data from one of its tables:
lcOBDCh = SQLSTRINGCONNECT([Driver={Microsoft Access Driver (*.mdb)};Dbq=FULL PATH TO ACCESS DATABASE HERE;Uid=USERNAME;Pwd=PASSWORD;])
IF lcOBDCh < 1
AERROR(laError)
MessageBox([Cannot connect to AccessDB ]+laError[1,2])
RETURN .f.
ENDIF
IF SQLEXEC(lcOBDCh, [SELECT * FROM MyAccessTable],[VFPCursor]) < 1
AERROR(laError)
MessageBox([Cannot get data from MyAccessTable ]+laError[1,2])
SQLDISCONNECT(lcOBDCh)
RETURN .f.
ENDIF
SELECT VFPCursor
GO TOP
BROWSE NORMAL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.