Sample of Excel & Access Database

[Prasad_Joshi]

Dear All,

Can anyone send me the sample file of Excel which is connected to Access database table & any manipulation in data can be done thru Excel to get results of calculations in Excel. I don't want to put any formula in Excel for calculation.

Thanks in advance.

Prasad Joshi.
:wot

[Ken Puls]

Hi Prasad,

I have a sample file attached at the bottom of my article on Exporting a range of excel data to a database (http://www.excelguru.ca/node/18). I've also got another article at my site on Retrieving data from a database to Excel (http://www.excelguru.ca/node/23).

I'm not sure what you're after specifically, but the two do illustrate how to read/write to/from an Access database from Excel.

[Prasad_Joshi]

Dear Sir,

Thanks. I got it. Now I am able to get the data from Access.

Prasad