Importing Data Problem

G

Gypsy

I am attempting to import excel files into an access dbase table. I have
arranged the excel file into the excact columns the way I want them to appear
in access. When I get to the point where I begin the "Import spreadsheet
Wizard", I'm o.k. until I come to "You can store data in a new or existing
table. Only the new table is highlighted, yet the existing table is there,
just not highlighted so I can't click on it. I'm going nuts! Can anyone
help?

Thanks,
 
G

Guest

hi,
no, your are not nut. access import all data into a new
table. access will not allow you to apend imported data.
i would suggest that you write a macro in access. first
write a append query appending the contents of the new
import table to the existing table. in the macro use the
tranferspredsheet method to import the data, then use the
openquery method to run the append query, then use the
delete object method to delete the import table after the
data has been appended. now you are set for the next
import.
there are severl ways to do it. this is one.
 
D

Derek Schauland

As far as I understand, Access will not allow importation of spreadsheets to
be appended to existing tables. If you import to a new database, the problem
should disappear and allow you to append records from within access, but not
excell.

Derek
 
S

Steve Smallman

Gypsy,

I think your problem is that the existing table has data in it (maybe not
but it's all I can think of right off).

Try importing the data into a new table and then append it to the existing
table.

Steve
 
Top