By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Tables from Excel database

P: n/a
I have a very basic Excel spreadsheet with records for staff.

I want to print tables in Access but include for each record the Excel
spreadsheet column header (e.g. cell A2) How can I print details from
an Excel spreadsheet for eacg record?

Steve
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 6 Apr 2004 11:06:42 -0700, se************@ntlworld.com (Selsley)
wrote:

Attach the worksheet to the Access database (File/Get External
Data/Link Tables). Then create a query that joins your Access table
with your Excel table on a common field.

-Tom.

I have a very basic Excel spreadsheet with records for staff.

I want to print tables in Access but include for each record the Excel
spreadsheet column header (e.g. cell A2) How can I print details from
an Excel spreadsheet for eacg record?

Steve


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.