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

  • Thread starter Thread starter zyzolus
  • Start date Start date
Z

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
 
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.
 
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.
Click to expand...
What is the way to achive that?
Click to expand...
Thank you for your advice.
Click to expand...
Zol
Click to expand...
Click to expand...

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

Zol
 
Back
Top