Import from Excel

R

Ripper

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. =)
 
K

Ken Snell \(MVP\)

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.
 
Top