Excel/Access  
Author Message
e3





PostPosted: 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





PostPosted: 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?
>