exporting blank fields into csv

  • Thread starter Thread starter Drobins
  • Start date Start date
D

Drobins

I have been searching high and low for a solutions for
this. I need to export a table in access to a csv file,
but I need to have blank fields/records still have double
quotes even tho there is no text in them. Access shows
the double quotes in the preview but when I finish the
export it drops them. It shows this in the
preview "bob","smith","","100 some street" but it
exports like this "bob","smith",,"100 some street"

Any ideas on how to fix this while exporting, my quick
fix is to find and replace ,, with ,"", It works but is
a pain once the files get bigger
 
Hi Drobins,

I'd do this by creating a query which added the quote marks to each text
field, e.g.

fMyTextField: Chr(34) & [MyTextField] & Chr(34)

Then I'd export the query to a text file using commas between the fields
but no quotes.
 
Back
Top