exporting data from excel into access pt2

[rxsims]

Currently I have an excel workbook, where I enter information, then I run a macro which generates a report and then generates another excel file with some data output. I do this each week. I use an excel spreadsheet because of the complex nature of the information (it is linked to other workbooks, there are large numbers of look-ups, equations, etc.).

How can I append the data I am currently exporting to another workbook into an MS Access table?

I have not converted the whole application to Access because it would take me months (at least) and Access can't perform the calculations I require easily. If I can export the finished (calculated) data to another workbook I should be able to fairly simply push/export the data from Excel into an MS table.

 

[PHV]

In Access VBA have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rxsims]

Is there a way I can drive this from Excel? Otherwise while I'm working in Excel, I still have to export the data, then go into access to import it.

 

[rxsims]

PHV - I see what you mean. I'll have to take a closer look.