Column data missing from Excel export.

[bigstav]

Hi, i am using the code below to export a Query to Excel ...

Dim sSQL as String
sSQL = "qry_CustomerDataIO_EncompassSiteTemplate"
DoCmd.TransferSpreadsheet acExport, , sSQL, exportFilePath, False

... the problem is that on just 1 particular PC (out of 12), the 1st column does not get populated in the spreadsheet. I have heard something about a Registry setting that sets the IMEX=1 / IMEX=2 setting for the oledb connection ?. Does anyone know if / how this can be changed ?, ido not want to alter the code if possible. Thanks for your help.

 

[ghudson]

Hi, i am using the code below to export a Query to Excel ...

Dim sSQL as String
sSQL = "qry_CustomerDataIO_EncompassSiteTemplate"
DoCmd.TransferSpreadsheet acExport, , sSQL, exportFilePath, False

... the problem is that on just 1 particular PC (out of 12), the 1st column does not get populated in the spreadsheet. I have heard something about a Registry setting that sets the IMEX=1 / IMEX=2 setting for the oledb connection ?. Does anyone know if / how this can be changed ?, ido not want to alter the code if possible. Thanks for your help.

Never heard of that problem and you are not creating any connectios with a simple TransferSpreadsheet. This should work for all users...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_CustomerDataIO_EncompassSiteTemplate", exportFilePath, False