Append table into a table

[JPritch]

Trying to use an append query to append records from Table1 into Table2. They are identical in structure...even went so far as to copy Table1 structure, and paste as Table2, just to make sure there were no discrepancies.

I am unable to run the append query. I get an "Invalid Argument" error.

I can view the records to be appended in the datasheet view, but it's only the "!" to run that is not working.

Query looks like this:
Field: Table1.*
Table: Table1
Sort:
Append To: Table2.*
Criteria:
or:

 

[neileg]

Change Table2.* to Table2

 

[JPritch]

I've actually tried that and it gives me a different error message about asterisks and the whole bunch. I've tried the error message suggestions to no avail.

I just noticed that my database size has ballooned to over 2GB. I wonder if this could be the problem.

This is weird b/c when I was about 3/4 of the way creating all my tables, the size was maybe 30 MB, I load the rest of the tables of similar size, and now it has balooned to 2GB. There are no other database objects other than my tables.

I will have to check into this...

 

[neileg]

Sorry, I wasn't thinking straight. Your SQL ought to look like this:

INSERT INTO tbl2
SELECT tbl1.*
FROM tbl1;

But i think from your description of the query grid that you will have this anyway, so I'm not sure what the problem is.

Compact and repair your database. This kind of bloat happens when running certain queries.

 

[JPritch]

It was the bloat.

Compacted and Repaired, and it runs like a charm. Thanks for the help.