Integrating Excel and Access

[Kenard]

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.

 

[Pat Hartman]

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.

 

[Jeff Boyce]

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?

 

[Joe Fallon]

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.

 

[Kenard]

Hey guys; How r u guys doin. Just want to say thanks a million, for your help
and advice.

Kenard