K kadara Registered User. Local time Today, 23:11 Joined Jun 19, 2010 Messages 43 Nov 13, 2010 #1 Hi, I would like to export some tables to Excel using OutputTo. When I open the Excel file with the exported table, I get a message "File error. Some number formats may have been lost." Please help. Thanks.
Hi, I would like to export some tables to Excel using OutputTo. When I open the Excel file with the exported table, I get a message "File error. Some number formats may have been lost." Please help. Thanks.
gemma-the-husky Super Moderator Staff member Local time Today, 21:11 Joined Sep 12, 2006 Messages 16,075 Nov 14, 2010 #2 try docmd.transferspreadsheet - see if that works correctly