Importing from Excel

  • Thread starter Thread starter Martha Stone
  • Start date Start date
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
 
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.
 
Back
Top