Importing Excel tales into an Access Database

[outhere]

Hi,
(About to lose my mind here...)
I have excel tables that I would like to import into an access table which already contains records. Seems simple enough, from access; import table, into an existing table, ... but then all I get are error messages "Microsoft Access was unable to append all the data to the table. The content of fields in 0 records were deleted or 0 records were lost due to key violations."

I've made sure all feilds in the excel template and access table were aligned and named identical, data type was identical (text and date), and even tried all that from .csv, same outcome...

Is there something I'm forgetting? Is there something I can do that omits these type of errors, is there someway I can get this to work properly; this is a daily task that shouldn't take me days to figure out..!!

Please help....Much Appreciated
Steve

the primary key that it adds, as opposed to following the set format 1,2,3,4; the added tables get primary ID's of like 6 or seven digits.

 

[Dreamboat]

Here's what I do, Steve, to avoid the problem altogether. Import it into a new table, then change the Access table design to be just like your existing table.

Create a union query to get the two table's data into one view, then turn the query into a make-table query, run it, and replace the two original tables with this new one.

Union query instructions:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q114731

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word