Importing Text

  • Thread starter Thread starter Snailspace
  • Start date Start date
S

Snailspace

Can I set up excel to import all my data as text columns instead of
general columns? The wizard almost always changes some of my data and
I would prefer to automate this process.
Thanks!
 
If you're really automating the process, record a macro when you specify each
field as text.

If you just want to make it a little quicker when you do it manually...
Select the first field (on step 3 in the xl2003 wizard)
then shift click on the last field
All the fields will be selected and you can specify text for all of them.
 
Third step of Wizard select the columns and Column Data Format>Text

You could record a macro to do this.


Gord Dibben MS Excel MVP
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing text files automaticly. 5
Importing Text Files Into Access 1
Excel 2007 text import as text not date 3
Import and Export Text data 2
Why this paste result? 4
Importing Long Numbers as Text cells 1
Can you change the Text Import Wizard column options 2

Back
Top