Importing From .XLS Begining on Row 10

T

TOMB

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

Aaron Kempf

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
 
K

Ken Snell \(MVP\)

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.
 
T

TOMB

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
 
Top