converting from excel to access

  • Thread starter Thread starter SirPoonga
  • Start date Start date
S

SirPoonga

The company I am temping for right now wants to try and automate their
engineering backlog process.

Right now how it works is the Receptionists emails one of the managers
a spreadsheet with the day's orders. That manager takes that and adds
it to a backlog spreadsheet. Then goes through the process of sorting
out orders in engineering versus released. Then does calculations and
such. Then creates a multitab spreadsheet to send on to the upper
managers.

First, does anyone know of a backlog system out there that could be
used instead of making something?

Second, if I make one this sound like something a database could do.
The problem lies in the calculations. One of the calculations deals
with promised due date and such. This uses the workday and networkday
excel functions. How would one do that in access?

I will have more questions about this, I'm sure.
 
Cool, that will give me a good start.

The other immediate issue is the first part of this process screams
database. I would like to implement some sort of intranet interface,
that seems like it would be the best. New orders could be entered in.
Employees with the right credentials can update status, etc... Then
just need a report page to sum up current statuses.

However I don't see that happening here. They bsically want to
eliminate the time consuming part of the process, copy and pasting
values, formatting spreadsheet, setting up formalas, etc.. that get
done each day.

So I am thinking a FE/BE sort of thing. an FE for the employee that
inputs new data into the system. An FE for the people to view the
reports, a FE for the people to change the status and comments.

However, I think they still want a nicely formatted spreadsheet with
the results. Is the only way to do this to export the data to a
spreadsheet, import a macro that does the formatting, adds formals if
needed, then run that macro?
 
However, I think they still want a nicely formatted spreadsheet with
the results. Is the only way to do this to export the data to a
spreadsheet, import a macro that does the formatting, adds formals if
needed, then run that macro?
Click to expand...

It's perfectly possible - even easy! - to create an Access Report
which has the LOOK of a spreadsheet (it won't, of course, have the
user-interaction flexibility of changing calculations, moving columns
and rows around etc). But if you want a printed report there is no
need to involve Excel; Access is quite capable of providing it.

John W. Vinson[MVP]
 
It needs to be something that can be emailed, hence excel.

Actually, I am thinking of putting this on the intranet, therefore I
need to find out if I can take/convert the code Douglas linked into
asp.net. First glance I don;t see anything out of hte ordinary that
the vb in asp.net couldn't handle.
 
It needs to be something that can be emailed, hence excel.
Click to expand...

I've had good success exporting Reports to Snapshot format; the
recipient needs to download the free snapshot viewer, but the quality
is excellent and the files are small.

John W. Vinson[MVP]
 
I think they want it in excel also because they tweak some of the
values. Which leads to my next question. Can I have access output a
spreadsheet but have a formula in a cell?
 
Back
Top