One table in each DB, need to combine...

[Shrubman]

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

[BrentHedden]

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.

[Shrubman]

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.

[BrentHedden]

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?

[Shrubman]

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

[BobWeaver]

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.