Cleaning up LARGE text files before importing into Access

[mpdsal]

Hello. I have some very large text files that I need to import into
Access. These files are basically SAP system reports that can be up to
100,000 records but they contain a boatload of data I don't care about.
My thinking was to clean up as much as I can and edit the files into
columns, much like Excel would do, except I am exceeding the 60,000
record limit. Can anyone suggest a good free text editor that will
allow me to cleanup enough and be able to do a text to columns (like
Excel) to import into Access? Perhaps another method? I truly
appreciate.

Mark

[JoeReed]

Mark,

If this data comes in a standard format each time then you can build an
import specification that only imports the fields you need. I use this
with a client that sends a file with way to much information. When I
import the file I have an import specification just for them that only
imports the fields I need.

You get to this specification area by getting the import process
started and then select advance in the lower right corner. Here you set
the layout information and the last item is skip which will allow you
to not import that information. Once you get it setup correctly save
the specification for later use. Works great...

[Darryl Kerkeslager]

"mpdsal" <m.*******@snet.net> wrote

Can anyone suggest a good free text editor that will
allow me to cleanup enough and be able to do a text to columns (like
Excel) to import into Access?

http://www.notetab.com/

Darryl Kerkeslager

[Tom Warren]

Can anyone suggest a good free text editor that will
allow me to cleanup enough and be able to do a text to columns (like
Excel) to import into Access?

http://www.textpad.com/

[PC Datasheet]

Import the data into a temporary database and use the power of queries to
clean up the data. When cleaned up, import the data into your working
database and delete the temporary database.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"mpdsal" <m.*******@snet.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hello. I have some very large text files that I need to import into
Access. These files are basically SAP system reports that can be up to
100,000 records but they contain a boatload of data I don't care about.
My thinking was to clean up as much as I can and edit the files into
columns, much like Excel would do, except I am exceeding the 60,000
record limit. Can anyone suggest a good free text editor that will
allow me to cleanup enough and be able to do a text to columns (like
Excel) to import into Access? Perhaps another method? I truly
appreciate.

Mark

[mpdsal]

I did download that. Is there a way to use the column separators or
breaks like you can in Excel? I am out there now trying to align the
data into columns. Thanks

Mark

[Darryl Kerkeslager]

"mpdsal" <m.*******@snet.net> wrote

I did download that. Is there a way to use the column separators or
breaks like you can in Excel? I am out there now trying to align the
data into columns. Thanks

Perhpas it's me, but threads seem to be not following in order nowadays.
You might want to quote, at least enough to tell for sure who you are
replying to.

If you are referring to NoteTab (again, I couln't tell), you can search for
and insert Tabs (^T), paragraphs /line breaks (^P), and other special
characters as needed.

Darryl Kerkeslager

[pietlinden]

Or just use an import spec, don't import the junk you don't want, and
then you're finished. I was thinking of using the power of queries
when I move...

INSERT INTO NewPlace
SELECT
FROM OldPlace
WHERE (((Stuff.WorthKeeping)=True));

(gotta be careful with the delete part... might inadvertently destroy
stuff I wanted!)