Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-08-2012, 11:37 AM   #1
scrummy199
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
AWF VIP
 
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,011 Times in 865 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
Reply

Tags
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 01:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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