Exporting to excel

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

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
 
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,

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!
 
Be sure that you've specified Export as the argument for the "direction" --
TransferSpreadsheet also works for importing.
 
Yes, it is set as export. Do you know what version of
Excel Access uses when using the "OutputTo" command?
 
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.
 
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
 
Back
Top