Hi folks,

Brand new with Filemaker and these forums. I have exported tables from Access database to Excel and then opened each one in Filemaker. Now I have multiple databses, each with one table. How do I get them all in one database?

Thanks,

Evan

Welcome to the forum!

A company named New Millennium makes a swell porgram that will do exactly what you want. It's a program called FMRobot - check out this webpage for more info - http://www.newmillennium.com/index.php?s...72ea55a1034be06

They make other products that are very handy and usefull.

I know I'm new to FM Pro and there may be some valid reasoning behind FM's decision, but I honestly am aghast that a professional relational database program can't do something as simple as copy a table from another database within the same program!

I'm supposed to buy a 500 dollar add on to do this?

Gimme a break.

Why would you need to pay $500 - the single-user license is $200. They do have a demo download available, but I don't know the fuctionality of it. I'm supposing that you only need to do this once, correct?

I'm no expert when it comes to SQL, but isn't there a SQL command(s) to copy/paste a whole table? Maybe someone here with more knowledge of SQL could come up with a solution?

I apologize. I was going by memory when I said 500. Even so, 200 is more than I care to spend for a one-time need.

Thanks for the input!

Evan

You can always create the tables in one file and then import the data into them, either from the excel files or from the FM files you generated.