Remove "save formatted" when saving as txt, cvs,tab, asc

B

Brandon

The save formatted box is grayed out and I need to change the settings from
Pipe delimited to comma delimited. When it was saved as pipe delimited it
changed the commas in my queries to vertical pipe lines and now I cannot open
the quieries and am getting errors messages.
 
J

Jerry Whittle

Need more info.

What are you trying to import or export: query, table, form, report?

How are you doing this: macro, code, manually?

What options are you using such as text delimiter?
 

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

Similar Threads

Exporting Dates problem 1
Excel Save As Options 2
TransferText using wrong format 0
Cell content surrounded by quotes when saving as tab delimited for 2
CSV 5
How do I export a query without a currency symbol to a comma deli 2
Problem encountered when saving worksheet as a text file 3
Data exports 1

Top