Importing large ascii file into access

[Peter_Whitaker]

ascii text file, 250 mb in size, 450,000 records fixed width; I have win2k pro, office 2k small business, added access 2003 for this project, 380mb ram, 900mb virtual memory, 650mHz p3. So far, I have contacted Microsoft and they helped me change the maxlocksperfile to the Jet 4.0. This did not work. I still get , "Link Text Wizard out of memory" message about 30 minutes after import.

Please help, project behind schedule.

Thanks,
Peter Whitaker

 

[Peter Whitaker]

Please disregard this posting as this is second posting.

Sorry and thanks anyhow.

 

[Albert D. Kallal]

I would actually write my own import routine for such a large file.

You don't mention how complex each line of the text file is, but I would try
writing some code to do the import.

I would consider using the file open command, and reading the raw ASCII line
by line.

If the the data is somewhat simple, then the code will not be too hard...

Have you considered writing a small loop to import the data?

 

[Nick Coe \(UK\)]

I'm afraid you will need to write some sort of import
routine using VBA to open the file then loop through it line
by line, appending each line to a table as you go.

Depending upon what the format of the line is you could chop
it up into fields using Left$, Mid$ and so pn, either during
import or after.

If each line in the file is longer than 255 chars and you
don't split it up into fields during import you will have to
use a memo field to hold the line.

If you have the Access Developers Handbook by Getz, Litwin
and Gilbert it has a good section on creating a text line
import class in vba.

Also have a look at the MVPs web site, specifically Chuck
Grimsby's 'Read Text File'
http://www.mvps.org/access/resources/downloads.htm


--
Nick Coe (UK)
www.alphacos.co.uk

---

"(e-mail address removed)"
in message

ascii text file, 250 mb in size, 450,000 records fixed

width; I have win2k pro, office 2k small business, added
access 2003 for this project, 380mb ram, 900mb virtual
memory, 650mHz p3. So far, I have contacted Microsoft and
they helped me change the maxlocksperfile to the Jet 4.0.
This did not work. I still get , "Link Text Wizard out of
memory" message about 30 minutes after import.

 

[Guest]

we managed to import more than a million records
what we did was, we converted the fixed width ascii file
into dbase then imported it into access table

-----Original Message-----
ascii text file, 250 mb in size, 450,000 records fixed

width; I have win2k pro, office 2k small business, added
access 2003 for this project, 380mb ram, 900mb virtual
memory, 650mHz p3. So far, I have contacted Microsoft and
they helped me change the maxlocksperfile to the Jet 4.0.
This did not work. I still get , "Link Text Wizard out of
memory" message about 30 minutes after import.