Question Importing a fixed-width messy text file (1 Viewer)

scrummy199

New member
Local time
Today, 11:09
Joined
Mar 8, 2012
Messages
1
So I'm very very new to the world of Microsoft Access, as in I just started using it in a reporting class about a month ago. For one of our assignments, we have to import a fixed-width text file, which based on all of the tutorials I've found seems easy enough, except the data seems pretty messy. It is not arranged in neat columns or anything, so when I go to put the markers in of where each column should be in the import wizard, it ends up messing up all of the data. Do I need to manually go through the text file itself and clean it up or is there an easier way to do this?

My professor has not been much help and is less-than-friendly, so I figured I would try and figure it out on my own before resorting to her.

Thanks so much!
 

John Big Booty

AWF VIP
Local time
Tomorrow, 03:09
Joined
Aug 29, 2005
Messages
8,263
Welcome to the forum.

Can you post a small sample of the data you need to import?
 

Users who are viewing this thread

Top Bottom