dasley

Thank you very much Colin. This is the correct procedure in order to read the datas within my FP5 file. Sincerely, thank you very much.

I'm using many tools to run SQL statements. The first one is the database explorer from the "Borland Database Engine" shipped with Delphi. When using this tool, i get error [key violation]. The others tools are those shipped with the ODBC SDK 3.5. When using these tools, i get error [database not open]. In final, i used MS Access to import datas from an ODBC DSN source (which is FM DSN). Unfortunately, MS Access returned me an error. I did many things but nothing works. I create some FP5 files AND i cannot export datas from FM to another database. I cannot believe it is impossible to do such thing. please help !!!

I tried to open the file C:Program FilesFileMakerTutorialSample FilesSample02.fp5 by using this statement : select * from Sample02 But it does not work (error : database not open). How must i open the database ? The ODBC driver does not accept any FP5 file name. The FM ODBC driver is 3.11.00.00

I'm new to FM, and i would like to export some FP5 files to another database. I correctly connect to the FM ODBC driver. THE PROBLEM IS : BECAUSE I do not know the table name generated by FM (i only know the fp5 file name where i save the table), i cannot call "SELECT, INSERT, ..." SQL statements through ODBC. How can i know the table name in FM 5 ? Thank you