Indexing on an Excel sheet

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

Guest

Hello all,

I need to import data from an Excel sheet. The data starts on row 6. What
is the best way to get to that data? Is it open the file then loop 5 times
then start moving the data into a table via record set, or does Access (vb)
have something that can do this better.
 
There are a couple of ways to do this. The easiest is to create a named
range in the Excel spreadsheet that defines where the data is. The in your
TransferSpreadsheet, you can reference that range. It is the last argument
of the method.

The other way is to use automation to open the spreadsheet as an Excel
object and read the data from the spreadsheet and write it to the table.
 
There are a couple of ways to do this. The easiest is to create a named
range in the Excel spreadsheet that defines where the data is. The in your
TransferSpreadsheet, you can reference that range. It is the last argument
of the method.

The other way is to use automation to open the spreadsheet as an Excel
object and read the data from the spreadsheet and write it to the table.
Click to expand...
 
No, a range is not dynamic; however, if you define the range starting at row
6 and continuing to the bottom of the spreadsheet, only the rows with data
will be imported.
 
Thanks!

Klatuu said:
No, a range is not dynamic; however, if you define the range starting at row
6 and continuing to the bottom of the spreadsheet, only the rows with data
will be imported.
Click to expand...
 
Back
Top