How do I copy a column of Excel data into an Access table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot export the Excel data into Access because the table already exists,
and as I understand it, you can only export the data to a new table! Please
Help!
 
Are you in Excel or Access when doing this?

If in Access you could rename the existing table; delete records in the
existing table; or append records to the existing records.
 
Well- I just imported my Excel data into a new table. I then attempted to
copy a column from one table and paste it into an existing column in the
other table. The problem is that now halfway through the paste everything
slows to almost unresponsive. Then after it finally pastes a new table is
created called "Paste Errors." I made sure to check and see if the fields I
was pasting to were formatted the same. I'm not sure what to do.

I also tried to import the new table into my existing table. I thought that
maybe then I could rename and delete the columns as I needed to get the
information in.
 
Copying and Pasting really isn't the right way to do this. You should use an
append or update query instead.
 
Back
Top