Importing From .XLS Begining on Row 10

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

Guest

I get 20 meg files in Excel which are difficult to open.

The first 9 rows contain information not needed for a table. Row 10 contains
the column headers.

Can I specify which row contains the headers or which row is the starting
point?

Thanks

- -TB- -
 
a professional level tool-- like SQL Server DTS wouldn't have any problem
with ths

you should get a copy of SQL Server DEvelopers Edition; I'd reccomend the
SQL 2000 version
 
If you use TransferSpreadsheet method (VBA or macro), you can specify the
"Range" of the data that are to be imported. This means you can tell ACCESS
that the data are in cells A10 through J2000, for example. This is explained
in Help files, but post back if you have questions about how to use it.
 
Thanks for the follow-up. I'm trying to avoid opening the excel file due to
the size. Therefore I would want to avoid using a named range.

But you did point me to the right solution, as I' just use
TransferSpreadsheet and select a range A10:J65000 for example since Access
will exclude the null data from Excel.

Thanks

TB
 
Back
Top