Exporting table to csv

[Menes]

Hi all.

I ave a table in access that has a column in the format single with auto setting for decimal places (I'm guessing this is 15 sig figs but I'm not too sure). What I'm trying to do is export this file as a csv so I can use it SAS. When I use the export function and select csv it truncates the data so all i get is 2 decimal places.
I can't export as a excel then rename as the file 1.4 million records long and so is too big for excel to handel. (I did try it anyway and it only exported the first 65000 rows).
I'm not an expert at all in Access, and would have little idea how to write any code that would allow me to do this.
Can anyone please help me as I urgently need to do this.

Thanks a lot.

Menes

 

[neileg]

Try using a query and apply the settings in the query. Then export the query.

 

[Moniker]

Look at response #5 in this post. You can export tables/queries of any size into Excel with the little program I wrote to do just that.