How to export from FM into SQL or Access

[bsarman]

I'm trying to export data from FileMaker into SQL or Access tables.

1)I tried using ODBC but did not have success. Anybody can give me guidance on using ODBC to perform this export?

2)Since I wasn't able to make the ODBC work, I tried to export the FM file into a dbf file and from dbf, I tried to export into an Access table.

The problem with this is that when the file is exported into a dbf file, all the field names are cut to only 10 characters. Therefore some fields such as avg_price_per_building and avg_price_per_lot appear to be the same fields when they are not. And this gives me an error message like this: "This export type does not support repeating fields. Only the first item from each repeating field will be exported".

I don't mind using any method as long as I can get this data out of FM and put into an SQL or Access table.

Thanks for your help.

Alex.

 

[lebisol]

http://www.filemaker.com/downloads/pdf/FMP_ODBC_gettingstarted.pdf

All the best!

> need more info?
:: don't click HERE ::

 

[bsarman]

Thank you for your help. But I'm trying to "export" from FileMaker into SQL. The ODBC connection you explained is to "import" data into FileMaker.

My objective is to "export" the data from FileMaker into either Access or SQL tables.

The problem is, when I try to set an ODBC connection for FileMaker it just does not work.

Thanks again.

 

[lebisol]

"when I try to set an ODBC connection for FileMaker "
this gets set/installed when u install FM....look for a patch/Update of your FM version, perhaps the ODBC never got installed properly
olso there a few FileMaker ODBC drviers (for SQL server, FileMaker Pro, for Oracle 8...)

check into this post....I will make some tutorials for you in the mean time.....do not worry this is relatively easy process...


> need more info?
:: don't click HERE ::

 

[lebisol]

so, your post should be "How to IMPORT from FM into MS SQL/Access"
follow this link:

http://www.MOSTARnet.com/tutorials/filemaker/FM_ODBC.zip

All the best!


> need more info?
:: don't click HERE ::

 

[bsarman]

I understand you're trying to help. However, you do not "import from something", you "export from something" and "import into something".

By the way, I checked it with other users,
the ODBC for FM simply does not work.

Thanks.

 

[lebisol]

I know that u can NOT "export" into or as Access -as FM will not create a Access file right on the spot...u can Export different "formats of files" that can be Imported into Access....
OK u deal with the wording - as long as we understand each other

"By the way, I checked it with other users,
the ODBC for FM simply does not work. "
LOL...I am one of those "other users" and it works!
IT DOES... if it is setup properly....I even took those screen shots while I was doing it.
Look at the PDF above.....or if want send me the .fmp file.
I know also that repeated fields and embeded documents can be a pain to export. Perhpas you have "something odd" in your FM files.....in any case...
All the best!

> need more info?
:: don't click HERE ::