Importing Excel objects

[sliptdisk]

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 [sig][/sig]

 

[DougP]

Well its easy
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.

[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[sliptdisk]

Well, I should have been more specific. I had gotten to the point where I had successfully imported the spreadsheet into the db; I'm just getting an error saying that the report doesn't recognize the query as a valid object. That's what the real problem is. I'll try to be more succinct, in the future.

Dan [sig][/sig]