Access and Excel

[sakthivels]

Greetings to everyone.

I have the following scenario. I maintain a table of clients and their details in a database. I also have an excel workbook with some details. What I require is that when I key-in the unique Client_ID in a Column in Excel, the other details needs to be pulled from the database.

Could some one show some light on this?

Thanks in advance.
S. Sakthivel

 

[DCrake]

What type of details do you want to get from Access? and why are you using an Excel workbook anyway?

David

 

[sakthivels]

Hi David,

My scenario is I have a table with the following details
Student_ID
Student_Name
Address
Course_Opted
Batch_No
Payment_Details

along with this table I have other tables wherein I maintain details about payments made, other facilities availed, etc.

In the excel worksheet, I want to summarize the information like Student_ID, Address, Other Payment Details made etc.

So whenever I enter the Student_ID in the Student_ID column field, other details need to be pulled in from the database tables.

I know this sounds weird but I have been asked to implement in this method.

Kindly guide me on this.

Thanks,
Sakthivel

 

[DCrake]

Considering that you are using Access I would generate the details in Access and display them on the form for validation purposes. Then have a button that exports the results to an Excel spreadsheet.

Anyway what is the receiver going to do with this infomation. If it is for viewing purposes only then why not send them a report from within Access.

David