Convert to csv

[Guest]

Hi,

I asked someone in our office and he said that when you convert a table in
acess to csv you need to have the acess table formatted as text, or else the
data will be stored in the csv file incorrectly. My problem was that there
were numbers in the acess table and the csv file only had 2 decimal places.

Problem now = when I change the format of the acess table to text - it says
error not enough space. There are 360,000 rows.

Is there a way around this problem?

Thanks

 

[Ken Snell \(MVP\)]

Create a query that is based on the table. For each field that doesn't
export correctly via TransferText (macro action or VBA programming), replace
it with a calculated field that uses the Format function to properly export
the data as desired.