Re: Upload FM Data to ODBC datasource


Joe Average schreef:

I need to upload data from a Filemaker 7 database to a SQL Server database
and need to know if the syntax to upload data from filemaker to the ODBC
driver.

FM7 on Windows XP to an SQL ODBC driver.

Do I have to upload data one record at a time? Is there any materials on
how to use an Filemaker to download, upload or update an external
datasource? I know how to import but can't seem to upload data. I get an
error saying only constants, expressions and variables are allowed. I think
it is just a syntax error.^

Joe, I am not an expert here, but you might want

a. Loop through your FileMaker records you want to upload and perform
an 'Execute SQL' script step for each record containing the statement:
INSERT INTO sqlTable(fieldA,f fieldB) VALUES ('value A', 'value B')
b. MS SQL Server supports the 'SELECT .. INTO' SQL statement which
allows you to select multiple rows and upload them in one batch into
the SQL Server database.

Make sure that all datatypes match, that your ODBC datasource is
properly configured (most drivers have a 'Test connection' button), and
- most important- start with very simple test uploads.

Regards,

Jeroen Aarts
-------------------
FileMaker 8 Certified Developer

.

Quantcast