Exporting to excel

[fgwiii]

Hello,

I am trying to find a way to programmatically export
several different tables into one workbook where each of
the tables exported would be placed in the workbook as a
different worksheet.

Thank you!

Fred

 

[Ken Snell]

Check out TransferSpreadsheet in Help.

 

[fgwiii]

I tried this command but whenever I attempt to run it I
get the folloing error:
"The Microsoft Jet database could not find the
object 'fredtest'. Make sure the object exists, etc..."

Any thoughts?

 

[Ken Snell]

Post the actual command step that you tried to use.

 

[fgwiii]

Ken,

Actually since posting this I have been able to get beyond
this error. But of course I now have other issues.

I am using a macro to export these tables out to an Excel
file and the first part of the macro I'm using is
an "OutputTo" command that works fine. But when I attempt
to run the "TransferSpreadsheet" command, I received the
following error "External table isn't in the expected
format."
I tried changing the Shreadsheet Type to each one of the
Excel output formats available, but I continue to receive
the error.

Thanks for you help!

 

[Ken Snell]

Be sure that you've specified Export as the argument for the "direction" --
TransferSpreadsheet also works for importing.

 

[fgwiii]

Yes, it is set as export. Do you know what version of
Excel Access uses when using the "OutputTo" command?

 

[Ken Snell]

Excel 95, I believe.

To see if it's the data that you're trying to export, or if it's the EXCEL
file, use TransferSpreadsheet for the first export (not OutputTo). See if
all works ok then.

 

[Guest]

Ken,

First of all I want to tell you that I appreciate all of
your help!

After re-examining each of the output properties I
discovered that I had other "issues" which I have now
corrected.

Thank you very much for your assistance!

Warm Regards,

Fred Wildauer