Question How can i make a request program with DB

[babafingo]

Hello everyone

I made a request program and DB with Excel. Program running way in that:

Coworker running the Excel file. This file contains macros. The user fill in the blanks like title name, title code and select working group. Then click send button.
During all of things, have to open Outlook.

After then, this program send a mail to me and open my databese, add row with title name, etc and user id. the program take this information from outlook. And then i open my databese. Click update button, add a new title name and new item nummer and save it. That's all.

And my question is, can i make this with Access.If can i, How?

Please, help me.

 

[NauticalGent]

It seems the easiest thing to do would be to Import the excel file as a "linked" file.

 

[babafingo]

Thanks for reply. But i want to make new program, new user interface. If linked solution is work, how can link excel and access.

And another question. Can i running Excel macros on Access.

 

[NauticalGent]

Choose External Data from the Ribbon, then Excel and then use the third option "Link data source..."

You would not need the macros to work in Access, they would work in its native environment.