changing the cell format on excel in vba code

[Guest]

I am exporting an access data to an excel spreadsheet using vba code. The
problem is the format for my time when exported to excel is different. How
can i change the cell format in excel using the codes in access and not in
excel itself. I use the code below to export. Thanks!

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3,
"tblTimeTable", "" & strInputFileName & "", False

 

[Jamie Collins]

I am exporting an access data to an excel spreadsheet using vba code. The
problem is the format for my time when exported to excel is different. How
can i change the cell format in excel using the codes in access and not in
excel itself. I use the code below to export. Thanks!

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3,
"tblTimeTable", "" & strInputFileName & "", False

Try a different approach e.g.

SELECT *
INTO
[Excel 3.0;Database=C:\ExcelFileName.xls;].ExcelTableName
FROM tblTimeTable;

Jamie.

--