|
|
|
Author |
Message |
e3
|
Posted: Tue Nov 25 02:48:37 CST 2003 |
Top |
Excel Misc >> Excel/Access
I have created an invoice template in microsoft excel,
and i have a customer information database in Access...
is there anyway I can use the information from my
database to input it into my invoice..
For example, rather than typing in a customers address
each time, can I select it from a list?
Also if I have an inventory list in access, can I use it
for the same purpose in an invoice template?
Excel68
|
|
|
|
|
Andy
|
Posted: Tue Nov 25 02:48:37 CST 2003 |
Top |
Excel Misc >> Excel/Access
This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html
Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm
It demonstrates how to use SQL in Excel's VBA to:
* create a database,
* create a table and add data to it,
* select data from a table,
* delete a table,
* delete a database.
You can also download the demonstration file called "excelsql.zip".
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
> I have created an invoice template in microsoft excel,
> and i have a customer information database in Access...
> is there anyway I can use the information from my
> database to input it into my invoice..
> For example, rather than typing in a customers address
> each time, can I select it from a list?
> Also if I have an inventory list in access, can I use it
> for the same purpose in an invoice template?
>
|
|
|
|
|
|
|