Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 03-08-2012, 11:37 AM   #1
Newly Registered User
Join Date: Mar 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
scrummy199 is on a distinguished road
Question Importing a fixed-width messy text file

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!

scrummy199 is offline   Reply With Quote
Old 03-08-2012, 12:04 PM   #2
John Big Booty
John Big Booty's Avatar
Join Date: Aug 2005
Location: Planet 10, by way of the Eighth Dimension
Posts: 8,263
Thanks: 113
Thanked 1,023 Times in 873 Posts
John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough John Big Booty is a jewel in the rough
Re: Importing a fixed-width messy text file

Welcome to the forum.

Can you post a small sample of the data you need to import?
...but they're only monkey boys!!!
John Big Booty is offline   Reply With Quote

fixed width , import

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Append the Contents of Fixed Width Text File to another Fixed Width Text File JohnLee Modules & VBA 1 12-21-2011 04:51 AM
open recordset from fixed width text file supmktg Modules & VBA 2 10-19-2011 09:13 AM
IMporting fixed width text file into a database Macjnr Modules & VBA 9 07-27-2009 06:46 AM
Export table to fixed width text file Lloyd Tables 1 10-06-2006 05:03 PM
Importing fixed-width text cabi Macros 3 03-03-2003 07:57 AM

All times are GMT -8. The time now is 10:40 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World