I'm fairly new to MS products and I need some NG help.

I'm doing a big construction project and I have serveral companies sending
me billing data in excell format.  I want to create a summary of my spending
to see if it matches up with my budget.

What I want to do is to centralize the accounting data in access.  My
problems is that each company has a different way of formating their data in
excell.

I thought that maybe I can create a form in access to allow each accountant
to input their data directly, but if they screw up, then I have bad data in
my database %P

Ideas?

I suugest the last thing you should do is try to get each company to change
the way in which it submits its data to you. I assume no standardised way
was specified when initial contracts were drawn up. To get all to agree and
follow a standard set by you would probably cause havoc and confusion -
besides which each company may have a valid internal reason for producing
its accounting data in its' own chosen way.

Since we are talking .Net here, it would surely be easier and potentially
less error prone to write a program using the office inter-op libraries, to
convert each company submission to a standard format Access, Excel or
whatever.

One of the great benefits of .Net is that in all areas from chosen
development language to data entry/storage you can allow people to do things
their own way! My experience has been to always let people do things the way
they want, unless there is a very valid reason for not doing so.

Regards
Terry



Show quoteHide quote

TreeView multiple selections
Javascript array to vb array
MSDN Subscriptions
Obsolete function
encryption padding problem with RijndaelManaged