Export Excel to Access

[Jim Alexander]

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.

 

[BrianB]

Your project would seem to lend itself to being driven by a table of
some sort. If this is the case, my advice to you is to redesign it.
Over the years I have seen numerous projects made far too complicated
by getting the groundwork wrong. Data tables enable the more powerful
tools to be used, especially pivot tables, as well as relating Excel
and Access more easily. Another benefit is that this will be easier to
change in the future. No need to change the base data, just the way it
is presented.

Regards
BrianB
================================



(e-mail address removed)>...