If you use Excel 2007 64K record limit disappears. I agree .dbf format is best.
Using Excel some formats can change, like zip codes can become numeric and lose leading zero, if your zips have one: I am in Northeast where they are all leading zeroes. What version of Access? I can give you detail instructions. Ron Carr From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Lee Sent: Thursday, October 15, 2009 3:46 PM To: [email protected] Subject: Re: Exporting from Access Richard, I've done it a few times by simply exporting the data out of access as a DBF option then importing it into filemaker. Then again I'm not matching too many fields which are easy to line up with my given field names in filemaker. This is easy as long as you can identify the field destination from the data when matching. I guess if you have access to the 'access' database then enter your field names in the appropriate fields in access so when you export you can easily identify destination fields. I did try to export the access data into Excel but found a problem. I had over 98,000 records to export out of Access but Excel would only accept around 64,000. However using the DBF format there was no problem. Lee Mills Richard S. Russell wrote: I could, given enuf patience, undoubtedly figure out how to export data from a Microsoft Access database in a form suitable for importing into FileMaker Pro, but I figure somebody here can probably tell me in under 30 seconds how to go about it. Also, if there are any hidden tricks or pitfalls I should be aware of, feel free to throw those in as well. TIA. --
