Import from Excel

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

Guest

What is the problem. I don't think Access will allow me to upload to a
current table. I imported a worksheet into a new table, no problem. I then
tried to import the EXACT same worksheet into that same table and got an
error. I understand why it imported the first time into the new table, but
why won't the exact same worksheet with the exact same data import again?

I was just testing the import feature for those of you windering why I would
import the same data tewice. =)
 
What type of error did you get? What's the structure of the table? Would
duplicating the records cause the table to have duplicate values for unique
indices?

Tell us a lot more, please, including how you did the import (via File | Get
External Data | Import ? or by TransferSpreadsheet ?), the structure of
your table, the structure of the EXCEL worksheet, etc.
 
Back
Top