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.

On Tue, 31 Jul 2007 12:24:29 -0700, zyzolus <(E-Mail Removed)> wrote:

>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 - Access MVP

On 31 Lip, 21:56, John Nurick <j.mapson.nur...@dial.pipex.com> wrote:
> 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.
>
> On Tue, 31 Jul 2007 12:24:29 -0700, zyzolus <zyzo...@o2.pl> wrote:
> >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 - Access MVP

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

Zol