Help with selective import from Excel.

[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

 

[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.

 

[Al]

No, no reason. I agree.
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.