Converting a ".lst" file into Access

[Vivek Menon]

I am a relatively new user of Access, and have received a
large database in ".lst" format. The file is 1GB.

This is is type of text file that Access 2002 cannot
import, and is too large for Excel or Wordpad to handle.

Any ideas on how I can convert it or get around this issue
to be able to get to the database through Microsoft Access?

Thanks in advance for the help!

 

[mackie]

list file???

can you figure out how may rows were there?
are each record in single row?

if you can open it in word, try to split the file
maybe 2 or 3 or more

then import it to access..

 

[Dirk Goldgar]

I am a relatively new user of Access, and have received a
large database in ".lst" format. The file is 1GB.

This is is type of text file that Access 2002 cannot
import, and is too large for Excel or Wordpad to handle.

Any ideas on how I can convert it or get around this issue
to be able to get to the database through Microsoft Access?

Thanks in advance for the help!

If the text file is in either a fixed-field-width format or a delimited
format, Access can probably import it if you just change the file
extension from ".lst" to ".txt". Have you tried that?

If it's in a weird format that takes special logic to unravel, then you
can write a VBA procedure to read the file line by line, parse out the
data applying whatever rules you define, and insert it into a table.

 

[Nick Coe \(UK\)]

It would help if you could report any error messages and
suchlike since different things could cause this including
finger trouble on your part. And yes I get finger trouble
too.

It could be a Unix/Linux type file so Access tries to load
it into one field and gets indigestion. IIRC Unix type
files have a Line Feed (LF) at the end of each line rather
than a Carriage Return/Line Feed combination (CRLF) used by
Windows and DOS. Mac's use CR on it's own but Access
shouldn't have trouble with that.

A 1GB file should import OK providing it doesn't take your
..mdb file up to or over the 2GB limit for .mdb files.

..lst is an arbitrary file suffix, it probably means list but
that's all.