import table

[wdisneymom]

I have a msaccess table in a database...I exported it to an excel file...How do I now add this table to an already defined fm7 database

[aaa]

Read help and Use from main menu:

Import records

[Lee Smith]

Hi wdisneymom, and Welcome to the forum.

To add to what I think [color:"blue"] aaa, is suggesting, FileMaker can deal with many different file formats. To see a list of formats and what they do, Open the Online Help (available when FileMaker is open), and type or paste this into the Index window.

[color:"blue"]file formats, About file formats

and then hit the button that says "[color:"green"]Display", a second window will open displaying the file formats with their descriptions. This information is also available in the Manual.

My recommendation is to save your excel file in different formats and then test out what happens when you import or open the files in FileMaker.

HTH

Lee

[wdisneymom]

did that but the records don't come in

[aaa]

Try to open .xls file as suggest you Lee Smith by FM7. It must be open. Then rename fields as you want.

[Leader]

The actual import steps starts at the FILE menu and the menu entries look something like:

FILE > IMPORT/EXPORT > IMPORT RECORDS

Then select either EXCEL or ALL FILE TYPES and go from there.

Once you've done it, you'll find it's simple. (Naturally.)

BTW, Disney Mom, I introduced FM to Disney in the late 1990s.

[wdisneymom]

thanks...it worked

I'm new to filemaker and I'll ask my son who works at Disney if he uses it

[Leader]

As in many companies, FM purchases are subject to the approval of a department's finance manager and sometimes IT. So often, when FM is recommended, the response is "But Microsoft Access is FREE!"

Yessssss... (I would say through gritted teeth) There's a good reason it's 'free'.

It was a real delight having progressive managers take a leap of faith.

Which location/department is your son in?