I have an Access database that is currently still evolving as some of the uses people want out of it are changing. The last changes made it so I have to throw out alot and rebuild from scratch. It is a relatively small database so this haphazard method is not to bad. I decided to do the current rebuild in both Access and Filemaker because I would prefer to just migrate it over to Filemaker.

I have several tables which are still usable and I want to import them all as a foundation for this build (the relations are not important they really started acting weird in access which is one of the reasons I am rebuilding). I was fooling around with things earlier and it appeared that I could only import them as individual files not import multiple tables into a single file.

I was working with Excell exports of the tables I wanted rather than Access database itself.

Is there a simple way of doing this? (I saw what appeared to be an obscenely complex solution somewhere) This question is mostly curiosity since it will not take much time to import the largest of the tables and then rebuild the rest.

I wish I could offer advice. I am looking for a similar solution. I get daily reports in Excel w/multiple worksheets that I import into a Filemaker database. The worksheets all contain the same fields. I have no idea why Filemaker didn't create an option to import all worksheets.

Can anyone advise or offer a solution.

Thanks!

Hi,

I can't see any way of acheiving this either, however, I quote from the FM7 User Guide, chapter 6, page 1, bullet-point 3 :

"You may want to go a step beyond conversion and migrate your files to FMPro 7, which you can do by either manually combining your files after conversion, or recreating your database in FMPro 7 and then importing data from the original files."

Okay ... how do I "manually combine" my files after conversion ? I mean ... could Filemaker really have left this simple feature out ?? It's in the manual ... so maybe it was left out just prior to it going on sale. Basically though, it seems that I have to go through a hugely laborious task ... just to recreate field names!!

Any ideas?

Grant Symon