Jump to content

Export from Access to FM Pro


bbaliner
 Share

This topic is 7180 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Dear Import/Export specialists,

I want to import the Excell file into File Maker Pro 5.0 while creating field names on-the-fly. In other words, I don't wanna go through heartache of creating same fields in FM as in Excell.

The scheme that seems good is importing it first into Access (this will create fields on-the -fly in Access), do all my querying in Access, and then export it into FM Pro.

I have Local Data Access companion enabled, and File Maker Pro ODBC driver istalled.

I created a Data Source in the same folder as Access table, but got an error:

ODBC--call failed. Create Table statement is not supported.

So from this I understand that FM Pro doesn't suppport DDL statements at all? Is it not possible to create a table at run-time?

Thank you much

Link to comment
Share on other sites

Do I read this right that you want to import an excel spreadsheet into FM Pro 5.

Why not just open filemaker and from within open the excel spreadsheet.

Or just drag the excel spreadsheet onto the Filemaker app icon.

This will then ask if the first row contains field names. Say yes and give the FMPro a filename.

Job done!

Link to comment
Share on other sites

Haaaaaa!!

That's great, dragging into FM icon worked!

That is the coolest feature, thanks very much.

I guess conseptually this answers my question, everything is done trough Excel rather than Access. I would think that it's also possible to export directly to Excell, but this is not one of the options, I must go through DBF or text file. I think this is Excel's fault rather than FM's, because Excel doesn't read FM's format. Is this correct?

Thanks again for your help, this was very useful.

Link to comment
Share on other sites

The problem seems to have been answered with the drag and drop of an excel spreadsheet into FMP.

I have an alternative approach. If you cannot bring Mohammed to the mountain then bring the mountain to Mohammed!

Set up the Excel file as the ODBC source and import the data into FMP rather than the other way around.

Ditto for Access, and many other sources.

I think it is significantly easier to get data INTO than OUT OF Filemaker....

Link to comment
Share on other sites

krafty,

I see your point, but I can't import into File Maker, since I don't have the fields in the FM file. My whole thing was I wanted to avoid defining the fields, and wanted them to appear on the fly. When there's no fields in FM file, Import option is grayed out for me.

But drag and drop certainly works.

Thanks for the help

Link to comment
Share on other sites

This topic is 7180 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.