Merging Tables

[nathan_1234]

Hello
I need to merge a set of Access tables. I am creating a database which will hold a large amount of records (upto 250 000 in one table). I am importing the data from an excel spreadsheet. As each spreadsheet is limited to 65000 records I had to save the file in 4 different spreadheets. However in Access I need all these files saved in one table. Can anyone please help me?

Thanks

Nathan

 

[trucktime]

Table

Check Access Help and this forum for 'Append Query'

 

[neileg]

I think you need to look at importing data and appending it to a table. You set up a table in Access and then import each spreadsheet in turn to this table.

 

[The_Doc_Man]

If this is a one-time operation, you have no value added to do anything except a hand import.

Create an empty table to hold the data you want, then append records to the table.

If you have trouble with this, try exporting the data from Excel in comma-delimited or other text format, then importing same to Access, one chunk at a time. Text imports ALWAYS allow you to specify to append to an existing table.

The reason I suggest creating an empty table first is that you will be guaranteed to have the data you want in the format you want when you are done. If you trusted the import wizards to do this and you had any tricky data cells in these sheets, the wizards are notorious for guessing wrong on the format you really wanted.

 

[neileg]

If you have trouble with this, try exporting the data from Excel in comma-delimited or other text format, then importing same to Access, one chunk at a time. Text imports ALWAYS allow you to specify to append to an existing table.

Hah! I've just spent half a day trying to import some data in csv format, only to discover some commas embedded in the data. A straight import from Excel worked first time.

So you have to have your brain in gear which ever format you use for the source file. (Wish I could find my brain, then I might get it into gear).