importing a worksheet info to an existing access table

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

Hello, i hope someone could help me. my plans are this.

i have a excel fire that has two worksheet. i like to import data from the
second worksheet to an existing access table. i've done this before and
someone now it's not working. something i am not remembering doing or
something is different. i only want certain data from this worksheet, but
when i think i've done it all, it gives an error. here is what i have done.

DoCmd.TransferSpreadsheet acImport, , "Location Information", _
"C:\Documents and Settings\wg7540\My Documents\Audit", True, "Excel Upload
A3:M3"

Location Information is table name and Audit is the excel file. excel upload
is the sheet and the data that i like to import should be limited to A3:M3.

Can someone help me? do i have to link the excel sheet to the access database?
 
What error are you getting?

I think "Excel UploadA3:M3" is not a well-formed range. If it is a
named range, just use the name. Otherwise just use the range A3:M3
 
Will said:
Hello, i hope someone could help me. my plans are this.

i have a excel fire that has two worksheet. i like to import data from the
second worksheet to an existing access table. i've done this before and
someone now it's not working. something i am not remembering doing or
something is different. i only want certain data from this worksheet, but
when i think i've done it all, it gives an error. here is what i have
done.

DoCmd.TransferSpreadsheet acImport, , "Location Information", _
"C:\Documents and Settings\wg7540\My Documents\Audit", True, "Excel Upload
A3:M3"

Location Information is table name and Audit is the excel file. excel
upload
is the sheet and the data that i like to import should be limited to
A3:M3.

Can someone help me? do i have to link the excel sheet to the access
database?
 
Back
Top