Import Range from Excel

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

Guest

I am trying to import part of one column of data from Excel into an Access table that is already populated. The table has 3 fields; one of which has the same name as the Excel Column. The table has no primary key & has no required fields. After the import of the new data. I don't care if the other fields of the newly created records in the table are blank. I tried copying & pasting; didn't work. Tried creating a TransferData macro; didn't work - got an error that Field F1 didn't exist in the table. Tried creating an append query; didn't work.

Is there a way to just populate one field of a table without having to create all the other fields in the Excel worksheet?
 
Number of fields being imported needs to match the number of fields in the
table and be in the same order.

To do what you seek, import the EXCEL file's data into a temporary table,
then use an append query to copy the data to your permanent table. The
append query will give you full control over the data -- something that the
import process does not.

--
- - - - - - - - - - - - - - - - -
Ken Snell
<MS ACCESS MVP>

Donna said:
I am trying to import part of one column of data from Excel into an Access
Click to expand...
table that is already populated. The table has 3 fields; one of which has
the same name as the Excel Column. The table has no primary key & has no
required fields. After the import of the new data. I don't care if the
other fields of the newly created records in the table are blank. I tried
copying & pasting; didn't work. Tried creating a TransferData macro; didn't
work - got an error that Field F1 didn't exist in the table. Tried creating
an append query; didn't work.
Is there a way to just populate one field of a table without having to
Click to expand...
create all the other fields in the Excel worksheet?
 
Back
Top