Help: I want to export data from access to excel and back to acces

[Guest]

Help,

I want to export data in access with the macro action transferspreadhseet to
a spreadsheet and use the same macro to retrieve columns from the excel
spreadhseet back to a access table; in the mean time the excel spreadhsheet
should performe vlookups and calculations on the imported data and fetch the
data for the upload to the access table.

However,,, it does not work?? Excel does not start automatically when I
perform the transferdatabase?

Who can help me?

Thanks

 

[Douglas J. Steele]

The TransferDatabase method doesn't start Excel.

You could use Automation to start Excel, but is there a reason you can't do
the lookups in Access?

 

[Guest]

OutputTo has an 'autostart' option, and you can also use the
'analyse it with excel' command, but both those create new
files. I think you are going to have to use automation to open
Excel.

(david)