Update table in access from excel

  • Thread starter Thread starter Boss
  • Start date Start date
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
 
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
Click to expand...

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.
 
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
 
Back
Top