CSV Export Number truncation problem 1

[jamez05]

Hi, I have a query that I use to export data to an excel file (Access 2003):

DoCmd.TransferText acExportDelim, , "qryDelimited", strFile, True

The numeric fields (doubles) return values such as "1.07989595" From the query. However, when I export this to a .csv and open it up in Excel, it appears as
"1.07". Does anyone know how to fix this?

 

[lameid]

Export manually and specify the datatypes. Save the specification while you do it and note its name.

Use it as the second paramater for your Docmd.transfertext

 

[dRahme]

Hello, one way to get around that is to convert the double into a string in your query - str(yourField).

Export out as a .csv and Excel will not drop digits when you open the file.

Hope that helps,

dRahme

 

[lameid]

I didn't connect to Excel... The data is likely in Excel, you just need to format the cells and / or widen the column to display the data.

 

[jamez05]

Thanks for your replies

Will look into your feedback over the weekend.

 

[jamez05]

HI,

I tried the str function and that somewhat worked. It changed the data correctly. However, you have to alias it, and I cannot use the same name as the alias without getting a circular reference error. These have to be named the same because its a template used for other programs as well.

I'm looking into exporting it manually. However, I haven't been able to find much info on this. Does anyone know of any good tutorials or have any info?

Thanks

James

 

[JerryKlmns]

Search for CopyFromRecodset method of the excel's Range object, so you could get a resultset from a query as please