Re: Access and Excel

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 21:42:49 +1300

Judith,

It seems likely that a properly designed and constructed Access
application would help your friend's work to be more efficient. As long
as the data in the Excel files is in a suitable structure, it will be
possible to import this data into the database, and for this process to
be reasonably automated. Possibly this would involve the use of the
TransferSpread*** method, followed by some data manipulation in Access
via append queries and update queries. And similarly, she will probably
be able to export the required data from her Access database to a
suitable format in Word, or PDF, or some such. 

-- 
Steve Schapel, Microsoft Access MVP
JudithJubilee wrote:
> Hello there,
> 
> My friends company are looking for ways to speed up so 
> she asked me.....
> 
> They have lots of sales and target data in fairly large 
> Excel spreadsheets. With formulas, charts, etc. They have 
> a number of sites that each month send them their figures 
> for the month either via email, fax or spread***. My 
> friend is then copying all this info into her 
> spread***.....please bare with me..........
> 
> She then has to do a Word document with information about 
> each month, which she is at the moment typing in again.
> 
> They also want to stop the various branchs from updating 
> the data afterwards and not allow the branches to see 
> each other.
> 
> What could they do? I've said I would help.
> 
> I immediately thought of Access with forms, security, 
> etc. Her boss has now said that he will only allow her to 
> have Access, the other branches will only have Excel.
> 
> Has anyone got any tips for having the branches always 
> use Excel and for that to update a database, which can 
> then be queried for mail merges?? I have to say I'm still 
> wanting to create some sort of Access database for her as 
> she is reentering 3 times at the moment.
> 
> Your help is much appreciated
> 
> Judith