Hi,

I am trying to perform export of a table in Access Database to a xls spreasheet.

For this I am using the command:

DoCmd.TransferSpreadsheet acExport, 8, "Report", Me!txtExportFileName, True

However I get a tick (') in the all the data exported. This happens for the fields which are of of Type TEXT only.

The Data Columns in the xls looks something like:

'Date 'Place
'1/1/2004 'Chicago
'12/1/2003 'Seattle

Now if I change the Date field type to DATE I do not see the ticks anymore. It looks something like this:

'Date 'Place
1/1/2004 'Chicago
12/1/2003 'Seattle


Has someone faced a similar issue before.

Any solution?

TIA

Hey,

The tick is an Excel thing. I think it does that to differentiate text versus functions, if I remember correctly. I may be wrong, but I know that Excel put's a ' in front for a specific reason.

If you plan to do anything with the data (import to another data source) I don't think you'll have a problem.

Brian

Well I found the solution:

If I use SpreadsheetType = 0 which is acSpreadsheetTypeExcel3 instead of 8 it works!!

No ticks are seen in Text Fields.

Thanks Anyways for your comments!