While designing my service reports using Excel 2002, I didn't take into
consideration the fact that I would need to export data to an Access 2002
database in the future. Therefore, I've got cells at different
locations throughout the worksheet that contain information that I need to
export. All information regarding exporting data to Access implies that one
has to start out with a tabular type Excel worksheet
in order to facilitate an import. I've had success using a macro to copy the
affected cells to another spreadsheet and then importing from that
spreadsheet. Unfortunately I have about six hundred service
tickets, (one per worksheet, each one a separate file) and need to come up
with a scheme that will allow me to do this in a more efficient manner. Any
ideas would be appreciated.

There are examples for exporting to Access at:
http://www.erlandsendata.no/english/...odao/index.htm

HTH,
Merjet

Thank you, I'll take a look.

Jim
"merjet" wrote in message
news:u6Rjb.156869$%h1.154267@sccrnsc02...
There are examples for exporting to Access at:
http://www.erlandsendata.no/english/...odao/index.htm

HTH,
Merjet

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".

The code is open and commented.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"


"Jim Alexander" wrote in message
...
While designing my service reports using Excel 2002, I didn't take into
consideration the fact that I would need to export data to an Access 2002
database in the future. Therefore, I've got cells at different
locations throughout the worksheet that contain information that I need to
export. All information regarding exporting data to Access implies that
one
has to start out with a tabular type Excel worksheet
in order to facilitate an import. I've had success using a macro to copy
the
affected cells to another spreadsheet and then importing from that
spreadsheet. Unfortunately I have about six hundred service
tickets, (one per worksheet, each one a separate file) and need to come up
with a scheme that will allow me to do this in a more efficient manner.
Any
ideas would be appreciated.