export to Text

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
 
J

Jackie L

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top