Importing table data from Excel

[giedrius]

Hi,
I seem to have a problem importing data from Excel sheet with MS Access 2000. For some reason Access would skip a few records without telling it (in fact it tells, but in a very strange way - "The contents of fields in 0 records were deleted, and 0 records were lost due to key violations").

Any ideas?
thanks

giedrius

 

[Sgt Shellback]

Hi,
I seem to have a problem importing data from Excel sheet with MS Access 2000. For some reason Access would skip a few records without telling it (in fact it tells, but in a very strange way - "The contents of fields in 0 records were deleted, and 0 records were lost due to key violations").

Any ideas?
thanks

giedrius

When you do an import Access has to first create a Table Definition to hold the data... It only looks at the fields in the first few records in the source file to determine how to set each field type in the columns...

If it sees data like 111213, 23314, 4122233... It will set the field as a long integer... Once the table is created if further down in the records in the same column it encounters 11G322... It cannot be imported because the data does not match the field def of Long integer...

This may be your problem.. But usually the error message will indicate a qty larger than 0 in one of the key violations that would tip you off to some being lost...

Was an ImportErrors table created? If so what is in it?

 

[neileg]

Just a thought. Have you installed all the service packs for A2k? It's more buggy than other versions, and this behaviour may have a bug as a root cause.

 

[giedrius]

Thanks for your good explanations.


I am not sure if have all the patches for A2K. Is it so, that if I install the latest, it will include all the previous?

giedrius