Linking spreadsheet to access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wjd01 - 13 Sep 2004 14:50 GMT

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

Reply to this Message

John Nurick - 13 Sep 2004 19:41 GMT

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,
[quoted text clipped - 3 lines]
>Thanks
>wjd01

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

wjd01 - 13 Sep 2004 19:56 GMT

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

Regards,
wjd

>-----Original Message-----
>Hi wjd,
[quoted text clipped - 29 lines]
>Please respond in the newgroup and not by email.
>.

Reply to this Message