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