Help with selective import from Excel.

A

Al

I would like to import some selected columns from an Excel spread sheet into
access 2003. I want to be able to control which row to start importing from
and which columns. Most likely the selections will always be the same once
established. The imported data is going to be the "row source" of a report
therefore, I need the import to occure automatically when the report is run
to get the updated data. Unfortunately, data is updated in this spread sheet
that I am trying to link or import to access. Can someone help?
Thanks
Al
 
P

Piet Linden

I would like to import some selected columns from an Excel spread sheet into
access 2003. I want to be able to control which row to start importing from
and which columns. Most likely the selections will always be the same once
established. The imported data is going to be the "row source" of a report
therefore, I need the import to occure automatically when the report is run
to get the updated data. Unfortunately, data is updated in this spread sheet
that I am trying to link or import to access. Can someone help?
Thanks
Al

Any reason you can't link to the data source and then base the report
on a query? (Or just query the spreadsheet in the link... there's an
example of how to do it in Developer's Handbook, and I'm sure there
are several here...) Then you could have the best of both worlds.
 
A

Al

No, no reason. I agree.
Al

Piet Linden said:
Any reason you can't link to the data source and then base the report
on a query? (Or just query the spreadsheet in the link... there's an
example of how to do it in Developer's Handbook, and I'm sure there
are several here...) Then you could have the best of both worlds.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top