Linking spreadsheet to access

  • Thread starter Thread starter wjd01
  • Start date Start date
W

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
 
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]
;
 
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
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top