Importing Text File Data

[BanditLV]

I'm trying to import data from a Fixed-Width Text File however, I've come to find out that the length of each line in the text file is quite long... I tried to import it first to Excel but when I did that, it would cut off some of the needed data in each line because Excel only imports to Column IV...

I tried importing using the "Get External Data, Import", however, the architecture is limited to approximately 32,000 and I'm needing at least 94,000 characters...

My next option (and one I would prefer to use anyhow), is importing using DAO with recordsets and all... I am unable to find any documentation on opening a text file and pick it apart as needed...

Has anyone done this before and if so, can you enlighten my headache?

Thanks in advance,

Roy McCafferty (aka BanditLV)
Las Vegas, NV

 

[kathryn]

Have you looked at the File commands? I am at a training session today, so I don't have access to my Access help files, but there are commands to open text files and read them in line by line.

Good luck. Kathryn

 

[BanditLV]

Couldn't find any "File" commands, per se... Still looking... Anyone know what she is talking about?

 

[kathryn]

Bandit,

Here is a KB article link for KB # 109393 "ACC: How to Import a Data File to a Control on a Form"

http://support.microsoft.com/support/kb/articles/Q109/3/93.asp

Also check out "ACC: How to Export Right-Aligned Fields to a Text File (95/97)"

http://support.microsoft.com/support/kb/articles/Q150/4/01.asp

which use the Open File command. I have no idea why I can't find it in the Help files; I thought I was going nuts! At least now I know that the commands exist!



Kathryn