Importing from Excel

M

Martha Stone

I had an Access database written for me to keep track of companies that
raise money for my organization. I have used it for a year with great
success. However, I have data for the 3 years prior that I'd like to get
into the system. I'm trying to import an excel doc that has the info I want
(for one year only) and the import wizard is giving me an "error occured"
message. How can I get the info from my 3 years of excel sheets into the
database?

Thanks!
Martha
 
S

Sheila D

Are all the headings in the Excel sheet the same as the field names in your table? If not you may need to rename, alternatively you could import to a new table and then use an Append query to get into the original.

Other problem I've had with Import is when the first field value is identified as a number then subsequent records may be text - Acces may have already defined field type as number and generates an error.

Hope this helps.
 
Top