Importing spreadsheet

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I'll try to be quick and to the point I have an excel
spreadsheet with the same column names as my Access table
(tbleWShopAttend). When I try to import them into Access
I see empty fields that show up despite the fact that
there is nothing there in my excel sheet. It shows up
like ID/WShopName/.../field1/field2/field3. Why does the
field show up despite the fact that nothing is in my excel
file?

When I try copy and paste it simply starts to overwrite my
old cells with the ones that im pasting with. I know this
is a quick fix but im overlooking things at this point and
I'm making this more complicated than it really is. any
ideas?

If this helps this is what the table looks like that im
importing to.

tbleWshopAttendID (autonumber and key)/ WShopName /
StudentID / AttendDate / Hours / WShopID /

I think my problem I believe is tbleWshopAttendID but i
could be wrong. Is copy and paste out of the question?
 
Hi Tom

I'll try to be quick and to the point I have an excel
spreadsheet with the same column names as my Access table
(tbleWShopAttend). When I try to import them into Access
I see empty fields that show up despite the fact that
there is nothing there in my excel sheet. It shows up
like ID/WShopName/.../field1/field2/field3. Why does the
field show up despite the fact that nothing is in my excel
file?

Probably because once upon a time there was something there. By default
Access tries to import the UsedRange of the worksheet. Try any of the
following:
-Create a new sheet and paste the data onto it.
-Delete all the columns to the right of your data area
-Define your data area as a named range and import that range rather
than the whole worksheet.
 
Back
Top