Update table in access from excel


B

Boss

Hi,

I have a situation where my team (50 people) update excel sheet in their own
systems. What i wish to do is to get entire data in one master table in MS
access. I can do it daily by importing multiple excel sheets.

But i need to view the entire data at runtime. All i should do for this is
that link access table at the backend so that when the user submits one
record in his excel sheet record gets updated in the master table of Access.


I know this is possible but could not write the code find it in google.
please help me with the code, This would help me a lot in the project.

Thanks!
Boss
 
Ad

Advertisements

P

Piet Linden

Hi,

I have a situation where my team (50 people) update excel sheet in their own
systems. What i wish to do is to get entire data in one master table in MS
access. I can do it daily by importing multiple excel sheets.

But i need to view the entire data at runtime. All i should do for this is
that link access table at the backend so that when the user submits one
record in his excel sheet record gets updated in the master table of Access.

I know this is possible but could not write the code find it in google.
please help me with the code, This would help me a lot in the project.

Thanks!
Boss

Basically, create a link to ONE of the spreadsheets, (assuming they
all have the same structure).
If they're all in the same directory, you can use DIR inside a loop to
walk the contents of the directory, then use an append/update query to
insert/update the records.

Sure it's possible.... Open up a code window, Hit F1, and introduce
yourself to the help files. If you're expecting someone to write this
for you, send money.
 
Ad

Advertisements

B

Boss

Hi,

I am facing a new problem, With the data which is getting updated in table i
have prepared a form in ms access which give me counts of the activities.

As i save the ms access form it gives me a error: Database in state by user
"admin". Then i cannot update records using excel.

please help.
Thanks!
Boss
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top