Integrating Excel and Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been given the task of designing a database that would store customer
information. However, It should be done in a way that when an invioce is
created in excel it will be automatically recorded in the access database.
All help in carrying out this process, is greatly appreciated.
 
You will need to add code to the Excel spreadsheet that is triggered when
the invoice is added. That code can add the invoice to the Access database.
I know it is hard for people to give up something they are comfortable with
but Excel just isn't very good as a database. You will be able to create a
better application if you create everything, including the data entry, in
Access.
 
Kenard

I'll take a related path to Pat's observation...

Why do you need a database, if your invoicing is being done in Excel? Put
another way, what functionality are you expecting to get from Access that
you don't believe you can get from Excel?
 
Pat,
I agree 100%.
When you have outgrown Excel, stop using it.
In this case just create an Invoice report in Access.
Much simpler and there are no integration problems.
 
Hey guys; How r u guys doin. Just want to say thanks a million, for your help
and advice.

Kenard
 
Back
Top