Importing from Excell 2002

[Dennis stratton]

Can anyone explain the procedure for importing an Excel
spread sheet? I keep geeting an error message that I
don't understand, and the "help" just does not seem to
help.
I have set up a macro for a transfer spreadsheet. It
picks up me spreadsheet and promptly gives me an error
message "Field F19 does not exist in destination table, t-
Membership". I've examined my input spreedsheet, even
doing a find on the spreadsheet, and can't find a field,
much less column with that name. What am I missing?

 

[Ken Snell]

If you tell TransferSpreadsheet that there are no field names in the first
row of the spreadsheet, and then you import that spreadsheet, ACCESS will
assign generic field names to the EXCEL columns and try to match them up to
the field names in the destination table. F19 means the 19th column in the
spreadsheet. I would imagine that your destination table does not have 19 or
more fields?

 

[Guest]

Thanks for your help Ken, I found that I had left out
the Key field. I expected access to assign it itself but
it didn't. Now, I can't get my screens to recognize the
data in the table. I beleave it is due to the indexed
key numbers starting at 1, instead of where it left off,
prior to my deleting the records.
Do you have any suggestions for reindexing the key so
that the Forms will recognize the new data?


Dennis

 

[Ken Snell]

You'll need to provide more info about how your form is "reading" the data.
Perhaps you need to change the way the form's recordsource query is set up?

Otherwise, you could create a new table that has the same structure as the
current table, and then use an append query to copy data to the new table,
using first a criteria that selects the "old" data, then run it again using
criteria that selects the new data. If your Key field is set up as an
autonumber, that should work for you (be sure to not! include the Key field
in the append query unless you want the old data's Key values to be used in
the new table).