Excel Mapping Application

[vpundir]

We are working on a small application In which we recevied some predefined excel reports from client side .we have to map them and store them into data base (MS Access).After that By using this database we need to generate some report at server side like suppose three clients(A,B,C) report merge and create a new report at server side.

What is the best solution for this type of problem.

[DrTechnology]

Hi vpundir

When you say <<< Excel Mapping Application >>> what exactky do you mean by Mapping?

<<<We are working on a small application In which we recevied some predefined excel reports from client side. >>>

OK I understand this perfectly.

<<< we have to map them >>>

Hum!!! what do you mean by Map? Is it to match column for column, row for row, or consolidate the data into one workbook?

<<< and store them into data base (MS Access). >>>

OK MS-Excel and MS-Access talk to each other easily. Check the MSKB for great articles about this topic. If you need specific help posta reply.

<<< After that By using this database we need to generate some report at server side like suppose three clients(A,B,C) report merge and create a new report at server side. >>>

Oh Geezz, you lost me here. I have no idea what you are talking baout. Is the report generated from MS-Access, or MS-Excel, or what? Is it 3 reports, a single report that goes to three clients, a single report in three parts that goes to 3 clients?

Not clear what you want to do, so please post some clarifications .

Hope to hear from you soon


Dr. Technology

[vpundir]

Well
Let me more elobrate the req. specification.There are a head office and its some regional offices (client-Server).At regional offices regional manager fill some excell sheet perdefined reports and send them to server through emails.Right now at server (head office) end head office operator again fill all regions reports into one report(excel sheet) manually .
So they want a application which can read these excel report which comes from regional offices and stores into data base(can be acces or MYsql) afer that by using this database they can genrate head office report.

I think now uo got it .

Vikrant

[DrTechnology]

Hello Vikrant

With all due respect <<< I think now uo got it . >>> I'll tell you when I get it. You see this is kind of a 2-way conversation, and when one party thinks something of the other party, before they ask, is not good...

OK I think the situation is much easier than you think it is.

1) Produce a workbook for each location. This workbook will be formatted in such a way that the Master application will know where all the data is in the workbook. For example, if you need to get the name of a person it will be ALWAYS found in column A. A phone number will ALWAYS be in column J, and the e-mail will ALWAYS be in column W, and so on.

2) The Master Application, the one that gathers all the data from all the workbooks will need to open, or link to, each of workbook get the data and then close the workbook. It will be helpful if all the workbooks were saved into the same folder.

So since you have the workbooks ALWAYS contain the name of the person in column A, the application does not need to find it, it knows the data in column A are names, and in column J are e-mails and so on.

Now I am not sure what part you need help with? Are you OK with VBA, or are you learning it?

Do you have a sample workbook that I may take a look at?

Let me know...

Dr. Technology
PS watch for your spelling, Please