Linking spreadsheet to access

[wjd01]

When linking spreadsheets to Access, is it possible to
setup so Access ignores the first few rows? For example,
the data I would like to collect in Access begins on row
5, so rows 1 thru 4 would be ignored.

Thanks
wjd01

 

[John Nurick]

Hi wjd,

If it's just a matter of ignoring the first few rows of data, use a
linked table as normal and then use a select query based on this to
return only the data you need.

Otherwise, here are a couple of approaches.

1) In Excel, assign a name to the range of data you want to import
(Insert|Range|Define). Then create an Access table linked to this named
range rather than to the worksheet.

2) Instead of a linked table, use syntax like this in a SQL query:

SELECT *
FROM
[Excel 8.0;HDR=No;database=C:\TEMP\Workbook.xls;].[Sheet1$A10:E20]
;

 

[wjd01]

Thansks for the suggestions John. I will try both and see
which works best to meet my needs.

Regards,
wjd

-----Original Message-----
Hi wjd,

If it's just a matter of ignoring the first few rows of data, use a
linked table as normal and then use a select query based on this to
return only the data you need.

Otherwise, here are a couple of approaches.

1) In Excel, assign a name to the range of data you want to import
(Insert|Range|Define). Then create an Access table linked to this named
range rather than to the worksheet.

2) Instead of a linked table, use syntax like this in a SQL query:

SELECT *
FROM
[Excel 8.0;HDR=No;database=C:\TEMP\Workbook.xls;]. [Sheet1$A10:E20]

;

When linking spreadsheets to Access, is it possible to
setup so Access ignores the first few rows? For example,
the data I would like to collect in Access begins on row
5, so rows 1 thru 4 would be ignored.

Thanks
wjd01

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.