Appending data from excel to access

[elaineng]

Hi

I am trying to import data from an excel spreadsheet to an access db. On the last step I get an error message saying Access was unable to append all the data.

in fact it doesn't append any of the data. No data is deleted or lost, and I have checked through table design vs excel sheet properties so I think that field type/size is not the issue.
If I choose a new database it appends all the data without any problems.

Any ideas? hope this isn't very obviously a newbie dumb-dumb type error!

Thanks

 

[David Eagar]

Double check the format of the excel columns & make sure they match the access fields. Often, the columns are 'autoformatted' into what Office thinks they should be ans a mismatch oocurs, ie trying to load tect into a numeric field

 

[neileg]

As part of the trouble shooting, import the data into Access into a new table and see what datatype Access thinks the fields are. High probability that this will throw up a problem.