Set text import query default to ANSI

M

Mike

I created an Excel 2002 CSV database query for importing reguarly created CSV
files. The default text format is OEM, which will not import correctly.
Setting the default table format to ANSI only works for files already within
the directory - new files default to OEM. Short of continually editing the
ODBC definition (which works), how can I set the default text format to ANSI?

TIA,
Mike
 

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

Change default text format from OEM to ANSI? 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Converting from the DOS OEM to Windows ANSI character sets 1
Encoding query - Ansi 10
*.LDB files not openning as plain-text? 0
Quote Marks Question 2
Column Widths, Importing ANSI txt files 1
How to ignore embedded linefeed in CSV quoted text fields? 1

Top