Importing Excel objects
Importing Excel objects
(OP)
I'm designing a report that has updatable fields (which I'm querying from a table in the database), plus, corresponding static fields of data, which I'd like to pull from an Excel spreadsheet that is stored on the network. I'm having a hard time figuring out how to do that, though. Does anyone have any suggestions? Thanks.
Dan
Dan
RE: Importing Excel objects
In Access click on the 'Tables' TAB
then right click in th ewhite space and click 'Link Tables...'
Next in the files of type (at the bottom of that box) Find Excel.
Find your excel file on the network.
Then choose which sheet if there is more than one.
Follow the prompts and then you will have a new Table with and Excel Icon next to it called Sheet1 or the name of your sheet if you renamed it in Excel.
Now you can use the new Linked table just like any other table.
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
RE: Importing Excel objects
Dan