Re: Upload FM Data to ODBC datasource

The connection works fine, I can veiw record from SQL database using MS
Access.

I think I am close to finished but I am getting a error message from the
ODBC Driver: Syntax error converting datetime from character string. Do you
know what I can to to fix the date format? I don't think Filemaker and SQL
store dates in the same way.

Thank you for your help

- Joe

"Jeroen" <jeroen@xxxxxxxxxxxxx> wrote in message
news:1156838659.423604.11790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

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