Import to an existing table from Excel

  • Thread starter Thread starter Peggy
  • Start date Start date
P

Peggy

I have a customer table that I have exported to an excel
file. I want to import it to my new database to an already
exisisting customer table. I set the old table up to have
the same number of columns with the same headings as the
new table, however, some of the columns of the old table
are empty. I thought I could file those in via forms once
it imports. I go through all the steps to import
data....all looks good. Then when I hit finish it tells me
an error has occured and it could not import the data. No
explanation.
 
I have found that it's much better to import EXCEL spreadsheet data into a
new, temporary table, and then to use an append query to copy the data from
the temporary table into the permanent table. It gives you more flexibility
in ensuring proper formatting/data type of data, and you can more easily add
/ ignore fields using the query.
 
An append query is a new thing to me. I will have to get
out my book as I am self taught. I did notice that I could
bring it in as new table, but then, of course none of my
queries worked. I may have to make a return visit about the
append query.
Thank you for your help.
 
I'll monitor this thread for about 30 days, so you can post back to this
thread if you wish.
 
Thank you very much. I brought it in as a new table then
just used the sissy way out and cpy and pasted it int the
old table.

Your a god!!
 
Back
Top