Linking Excel table to Access database starting from a specific row.

[zyzolus]

Hello!
I would like to link an Excel table to an Access database. However, I
would like to skip a couple of first, consecutive rows from Excel
datasheet. That datasheet is read-only so I can't use a named range or
modify it in any way.

What is the way to achive that?

Thank you for your advice.

Zol

 

[John Nurick]

Hi Zol,

Instead of using a linked table, create a query, switch to SQL view
and type in the appropriate SQL statement using syntax like this:

SELECT *
FROM [Excel 8.0;HDR=Yes;database=C:\Fdr\File.xls;].[Sheet1$A3:E99]
;

By starting the range at A3 you omit the first two rows. The HDR
argument controls whether the first row of the range is treated as
data or column headings. If the latter, the headings are used as field
names; if the former, the fields are named F1, F2, .. Fn.

 

[zyzolus]

Hi Zol,

Instead of using a linked table, create a query, switch to SQL view
and type in the appropriate SQL statement using syntax like this:

SELECT *
FROM [Excel 8.0;HDR=Yes;database=C:\Fdr\File.xls;].[Sheet1$A3:E99]
;

By starting the range at A3 you omit the first two rows. The HDR
argument controls whether the first row of the range is treated as
data or column headings. If the latter, the headings are used as field
names; if the former, the fields are named F1, F2, .. Fn.

Hello!
I would like to link an Excel table to an Access database. However, I
would like to skip a couple of first, consecutive rows from Excel
datasheet. That datasheet is read-only so I can't use a named range or
modify it in any way.

What is the way to achive that?

Thank you for your advice.

Zol

Thank you for your very quick response!
This solution looks pretty resonable!

Zol