
Importing a text file - Smallctx.txt [01/01]
Quote:
>I need to import a large delimited text file so that I can sort the data=
and=20
>manipulate it. I haven't had any luck so far, so I decided to do it=20
>line-by-line using Line Input #1 and parsing each line.
>Needless to say, this is VERY time consuming, so I was hoping
>someone out there could help me out.
>The real file is a few MB, but I am attaching a few lines. Can someone
>help?
David,
You can ATTACH a text file to Access and then deal with it just as you
would any "normal" table (i.e. SQL Appends, Queries, etc.). If sorting =
is
all you really need to do, why not try using Excel as an OLE object, open
the file (as a worksheet), sort, then save.=20
I have done both, if you need a code sample let me know.
--
John Wood
Manager, Database Administration
VWR Scientific Products
West Chester, PA
610-429-2840
"Nearly all men can stand adversity,
but if you want to test a man's character,give him power."