Consolidating data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Protected Quartely report format was designed and sent to 20 clients in
different locations to fill and send it back to me. Now I end up having huge
data in Excel, difficult to work on. I wanted to work with the same data in
Access and so created tables containing all the codes by using IMPORT
facility. Now how to go about having the data into it as sent by 20 clients.

Please suggest me easiest way of getting the data from Excel to Access as
Importing 20 excel files (each having 15 worksheets within it) to Access is
becoming very much tedious.

Is there any other option which could ease my work??
 
If you have a web server and most users have web access, set up Data Access
Pages or some other web program so that the clients can directly input into
the database.
 
Dear Mr.Whittle,

Thanks for your reply. Am sorry we don't have web server facility.
Can you suggest any other way of doing it.

Shweta
 
If they all have Access, you could try using replication instead of
spreadsheets.

Another thought would be to try to reduce the number of worksheets.
 
Back
Top