>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