export to Text

  • Thread starter Thread starter sf1234
  • Start date Start date
S

sf1234

I am exporting a table to text to email.
If the field is "blank" in my table, the receiver wants it
to look like this: ",,"
When I export to Text, the apostrophe and commas do not
come up like that. I suppose because Access is not
allowing it. I am working out of Access 97.
If I could get this to work (maybe with coding???) I would
be finished! Please help!

SF
 
Are you exporting as fixed width? Exporting as comma delimited should put the commas in for the blank field.
 
Back
Top