Excel/Access

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

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?
 
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"
 
Back
Top