Export Binary Data type using DoCmd.OutputTo

D

Don

I have been asked to help troubleshoo the following....

We have a database with a Make Table query that results in
three "binary" field types being created (how... I am not
sure).

I any event, we want to automatically open the resulting
table in Excel. What is happening is that Excel does open
the resulting data automatically, but all the columns
(fields) with the "binary" data type are blank!

I am using the following code....
DoCmd.OutputTo acOutputTable, "NewTable",
acFormatxls, "N:\MyFile.xls", True

On the other hand, If I export the table manually using
File... Export, save it as xls, and uncheck the Save
Formatted box, and then open the resulting file, the
resulting data displays just fine.

I guess is there any way I can uncheck this option when
performing the command above? Any other way to make the
data to display properly?

Thanks in advance,
Don
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top