Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
C.M. Warden
 
Posts: n/a
Default Sharing information between Access and Excel

I have a real Dilbert kind of assignment that I am hoping that someone can
give me a hand with. Currently my company uses a spreadsheet to calculate
the commision for the sales folks. They want to have a way of saving the
information for historical reasons and want a database. (Personally I don't
see why they just don't save off versions of the database but I don't get to
make that kind of suggestions.)

The spreadsheet is not that complex so there really isn't much that the
database would have to store. It does, however, have a number of
calculations that are based off of the few imputs.

My problem is this. How do I, using either Access or Excel XP, create a
means of displaying the information in a format familer to the users. When I
try to use a Excel drop-in in a Access report and try to import the
information in I get an error that the database is already in use. When I
try to go through Excel, I can't seem to find a dynamic way to send a query
to Access to pull the information that I need.

I might be missing something simple but I am beating my head against the
wall at this point so I could use a fresh perspective.

Thanks

  #2   Report Post  
Dave O
 
Posts: n/a
Default

W.W.D.D.
What would Dilbert do?

To summarize: you have a working Excel application that is doing the
job, but the suits want it entered in Access. Do you know why? Do
they expect the work flow to expand so dramatically that it will
require a database?

You may want to explain that Excel is much more intuitive for most
people, and that the amount of time required to develop an Access
database to do a job that's already being done is not worth the payoff.

The pure Dilbert solution is to continue doing it in Excel and create a
dummy database that provides the "cool"? factor the suits are looking
for. Go on vacation and have someone else try to generate your report
from the dummy database; they'll fail because it never worked in the
first place. Your choice at that point is to either casually provide
the report or "work all night to recover the data" and provide the
report, again from Excel.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hot to access deleted information in excel sheets Goeran Zaengerlein Excel Discussion (Misc queries) 3 January 18th 05 10:41 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 07:03 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:45 AM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 03:32 AM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"