I imported a table and I only have access 2003 so I can't import to much data in so I split the information into 14 different tables. I want to append the tables together but I'm not getting the pop message that I'm moving so many fields to the new table I created with the copy and paste with no data only the fields.  Is there anything that I'm doing wrong?

---

Reply from Richard Rost:

Wow... how big is your table!? Even with Access 2003, you should still be able to have 2 GB in a database. I have Access 2000 on one of my machines and it routinely works with 1 to 2 GB tables.

Don't use copy and paste to move that much information. Use an APPEND QUERY like I show you in class.