Import text file to only one Field

[Guest]

I am trying to import a text file into Access. However, I need it to be
brought in just one field, then I can run some code to separate out the
different fields. I figured importing it as fixed width would work best, but
I need a specification. I searched for examples, but didn't find anything.

Anyone have a good way of doing this?

Thanks,
Scott J.

 

[Ken Snell \(MVP\)]

Do the import process manually (File | Get External Data ... | Import). On
the wizard screen (after you select the file to be imported) is an Advanced
button. Click that, and set up and save your specification. Cancel the
import, and then use the specification name in your TransferText macro or
VBA code.

 

[Guest]

Thanks for the reply! I'm guessing the specification is stored within the
Database? I I need to have multiple people perform the function.

Scott J.

 

[Ken Snell \(MVP\)]

Yes, the specification is stored in one of the "hidden" system tables in the
database file. So other users who're using the file (or a copy of it) can
also use the specification once it's been created and saved.