import txt wizard won't let me split colums or adjust imported col

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text file with about 100,000 rows and about 20 columns.

I want to import this text file as a new table. As a result, when I am in
Access and select the text file to import, Access automatically brings up the
import test wizard.

Which is fine. however, when I seledt delimited, and then select next the
text wizard separates all of the columns for me automatically.

(when importing files text files in excel, the text wizard allows the user
to define,l change or delete where the columns begin, end and how wide or
narrow they are)

is there way to have this type of control over the text data that I am
importing into access?

Or is there another way around this?
 
If this is an ordinary delimited file (e.g. with a comma or tab
character between each field), the import routine automatically splits
it on the delimiter you specify. You get to choose field names and
types, and can skip fields you don't want.

If it's an ordinary fixed-width file, you can specify the start and end
positions for each field.

Anything else, you'll have to either process it before importing or
write custom VBA code to split it up the way you want.
 
I guess I will have to process it some other way before or after import,
thanks for your help
 
If you paste a sample of the data into a message, and show how you want
it to be divided into fields, someone here will probably be able to
suggest something.
 
Back
Top