Cam Raben
asked on
need to copy 130,000 rows from one access db into another access db
Hi,
i need to copy a large number of rows from one Access db (31.9 MB) (db_1) into another Access db (57.6 MB) (db_2). db_1 has 130,172 rows. db_2 has 208,778 rows. Both db's have the same structure.
Thanks!
i need to copy a large number of rows from one Access db (31.9 MB) (db_1) into another Access db (57.6 MB) (db_2). db_1 has 130,172 rows. db_2 has 208,778 rows. Both db's have the same structure.
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It imported successfully. Thanks much!
ASKER
ps Now that I have both tables in my original db, how would I append the rows of the newly imported table into the table in my existing db. (both tables are identical)
just create an append query
ASKER
I did and got a warning that "MS Access can't append all records in the append query: MS Access set 0 fields to Null due to a type conversion failure, and it didn't add 66201 records to the table due to key violations. ??
ASKER
It appears to be due to "key" violations. Both tables have an ID field that is an autonumber primary key. I think the failure to append 66,201 records has to do with this key but I'm not sure. ?
ASKER
Ok, I got it to work but..... I had to remove my ID field (autonumbered PK) from both tables. From what I know about relational db's this is not recommended. Is this true, and if so, is there a workaround to retain the integrity of my PK field? If I don't need it so be it, but I want to make sure before I go further.
Thanks much for any advice you'd give me on this Aikimark (this is that database of NC water quality data, btw).
Thanks much for any advice you'd give me on this Aikimark (this is that database of NC water quality data, btw).
The ID field of the target database will automatically increment. This might only be a problem if you have other tables that you join with these two tables on the ID column. Otherwise, no problem.
ASKER
Excellent - thanks.
ASKER