Jump to content

Microsoft Access Database?


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

Recommended Posts

I have been supplied a Microsoft Access Database, and was wondering what would be the best way of importing it into Filemaker Pro. Could I use the ODBC driver for Access? I am on a Mac, and understand that Access is not available on Mac, but could I do the import from a PC?.....Or, should I export the data into an Excel spreadsheet, then import it into Filemaker. I have tried this method, but it didn't export all my records...only 65536 out of the 79000+ records. Is there a limit?

Link to comment
Share on other sites

quote:

Originally posted by kim:

I have been supplied a Microsoft Access Database, and was wondering what would be the best way of importing it into Filemaker Pro. Could I use the ODBC driver for Access? I am on a Mac, and understand that Access is not available on Mac, but could I do the import from a PC?.....Or, should I export the data into an Excel spreadsheet, then import it into Filemaker. I have tried this method, but it didn't export all my records...only 65536 out of the 79000+ records. Is there a limit?

I would export to Excel. It sounds like you ran into a 64K limit. Access must only be able to export 64K records at a time. Try exporting in 2 batches via a query. Then from Excel, save as a CSV file and import into Filemaker.

This will also allow you to do any cleanup to the data before bringing it into Filemaker.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

quote:

Originally posted by captkurt:

I would export to Excel. It sounds like you ran into a 64K limit. Access must only be able to export 64K records at a time. Try exporting in 2 batches via a query. Then from Excel, save as a CSV file and import into Filemaker.

This will also allow you to do any cleanup to the data before bringing it into Filemaker.


The limit of 65K lines is actually an excel limit. I have ran into this many times because I worked with over 200K lines. Just some side info. smile.gif

Link to comment
Share on other sites

This topic is 8548 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
×
×
  • Create New...

Important Information

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