Scripting an ODBC Import

[dburge]

Hello!

I have an Access database that I have created a System ODBC Datasource for. Within FileMaker 6, I import a table from Access. This process works correctly when done through the menues. I am trying to script this procedure.

When I save the script and test it, it continually opens the File Open dialog box. Even though I am importing from ODBC rather than from a file. If I press cancel, the script fails.

I would be very appreciative if anyone knows how to script an import using ODBC and can help me out.

Thanks!

Daniel Burge

FileMaker Version: 6

Platform: Windows XP

[Reed]

Did you check the import without dialog in the import script step?

[dburge]

Yes, here are the settings:

Restore Import Order: Checked

Perform without Dialog: Checked

Specify: Unchecked

The same error occurs no matter if Perform without Dialog is checked or unchecked.

Thanks for the help so far!

Daniel

FileMaker Version: 6

Platform: Windows XP

[slstrother]

You will need to specify ODBC as the file type, select the appropriate DSN and enter the query. The query can be stored within the script or in a global field.

[dburge]

Thank you very much! It works now!

Daniel