Help with selective import from Excel.

  • Thread starter Thread starter Al
  • Start date Start date
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
 
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
Click to expand...

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

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.
 
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.
Click to expand...
 
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.
Click to expand...
 
Back
Top