Importing Text Files

G

Guest

I regularly import text files that are 'Comma' delimited. The 'Text Import Wizard' always defaults to 'Tab' delimited

How can I change the default options in the 'Text Import Wizard'

Bill.
 
R

rbanks

I import comma delimited files every day, and I don't think it can b
done. I allways have to click next then, comma delimited.

I know I'm "dating" myself here, but it was actually easier back in th
LOTUS 123 days where your could create and save a parse template, the
use it each time.

Sorry I couldn't help.:
 
D

Don Guillett

Excel should remember from the last time you did it.
OR, record a macro while doing it and use that.

--
Don Guillett
SalesAid Software
(e-mail address removed)
bills said:
I regularly import text files that are 'Comma' delimited. The 'Text Import
Click to expand...
Wizard' always defaults to 'Tab' delimited.
 

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

Import External Data 1
Import Data, using a command line switch 5
Importing Text Files Into Access 1
Change Default Settings for Data Import 1
Text Import Wizard 1
Tab delimited text file import on double click 2
Import comma delimited text 2
Paste comma delimited text into a spread sheet 5

Top