Integrating Excel and Access

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" wrote in message
...
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.

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?

--
Good luck

Jeff Boyce
Access MVP


"Kenard" wrote in message
...
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,
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.
--
Joe Fallon
Access MVP



"Pat Hartman" wrote in message
...
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" wrote in message
...
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.

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

Kenard

"Joe Fallon" wrote:

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.
--
Joe Fallon
Access MVP



"Pat Hartman" wrote in message
...
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" wrote in message
...
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.