Yes, that is the problem. The Range object does not include the first row of
data, so ACCESS doesn't see the 'field names' in the spreadsheet until you
modify the Range's scope to include that first row in the spreadsheet.
You need to modify that Range's scope in the EXCEL spreadsheet. Delete the
Range and then recreate the Range the way you want it to be in terms of the
desired rows/columns.
Yes, that is the problem. The Range object does not include the first row
of
data, so ACCESS doesn't see the 'field names' in the spreadsheet until you
modify the Range's scope to include that first row in the spreadsheet.
OK, theres already a Range in the Spreadsheet, it's called Table1 and I can't
delete it for some reason. The only thing that I can do is change the name of
the that Range.
I can add another Range, but I still have the same problem :S.
Ken said:
You need to modify that Range's scope in the EXCEL spreadsheet. Delete the
Range and then recreate the Range the way you want it to be in terms of the
desired rows/columns.
I am not an expert regarding EXCEL, so you may want to post a question in
the EXCEL newsgroup about how to fix the range. Otherwise, change the name
of the current range, then create a new range with name of Table1 that
includes all the rows on the spreadsheet.
OK, theres already a Range in the Spreadsheet, it's called Table1 and I
can't
delete it for some reason. The only thing that I can do is change the name
of
the that Range.
I can add another Range, but I still have the same problem :S.
Ken said:
You need to modify that Range's scope in the EXCEL spreadsheet. Delete the
Range and then recreate the Range the way you want it to be in terms of
the
desired rows/columns.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
