Copying data from one table to another table

[lasd]

Hi

I hope someone can help me. I currently have two tables ImportTable and TestTable. TestTable contains two columns of data with approximately 3000 rows. I need to copy the information here into my ImportTable. My ImportTable currently has 15 rows and when I go to copy the data in i can only paste in 15 rows of the 3000 rows in the TestTable. Do I have to go and insert 3000 rows of some kind of data in my ImportTable to be able to import the data from TestTable???
I hope I am making sense. Thanks in advance for the help
So grateful
Lasd

 

[dhulbert]

Just wrinte an append query with TestTable as the source and ImpotTable as the destination.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)