Link between Access and Excel

[kruger101]

Hello
Im having trouble with access and im kinda new to it so ne nice
Ive searched the forum and i havent found anything helpfull...

I want to link a single cell in excel, another file, to my access query... how can i do this?? Thank you in advance.

 

[Smart]

You can link to your excel file

File ,getexternal data, link tables
select the excel file

This now appears as a link table in your database and you can query it as you would any access table

 

[kruger101]

Thanks for the help
but
I want to link a single cell. How can i do this?? I managed to link a whole worksheet from excel, but i only want to link a single cell.

Ive tried a hyperlink, but i need to do calculations with the data from the excel cell i want to link, so a hyperlink is no good.

Any help would be very much appreciated.

Thankyou

 

[neileg]

You're going to have to explain what you want and why. Access is a database so it expects its data in tables. You can have a table with a single record, but you don't give us enough information to be able to help you.

 

[kruger101]

Sorry for not giving enough info... I'm new and I've been breaking my head over this.

Ok I've made some calculations with graphs and sums in Excel. Its a lot of work, so I dont want to do everything over again in Access.

There is one specific calculation in Excel, and I want to link the answer of the equation to an Access Database. It is possible to link a whole worksheet, but I only want to link the data value of one cell, and I cannot figure out how to do this. I then want to use the value of the calculation from Excel to do more calculations in Access.

Ive tried to find my answer on this forum and in the help files... but I cannot find anything.

I hope Ive given a good enough explanation.

Thanks for all the help guys/gals I appreciate it very much.

 

[neileg]

Perhaps you can add a new worksheet in your Excel workbook and populate that with the value you want. Then you can link that worksheet as a table with a single value.

 

[kruger101]

neil

Thank you, easy as pie now. Can't believe I didn't think of that myself.