Importing Text Files

[Guest]

I am trying to import a very fixed length TXT large file but keep getting the
following message "The Microsoft Jet Database engine could not find the
object"

I have taken the the first record and created a sample file, get the same
messge at importing the file. the file is a fixed length TXT file, I have
tried linking the file without success. I have changed the file name of the
sample file to "BSEC" to avoid the 8.3 issue, still no avail. The Name Field
is 300 chrs which prevents me from creating the table manually as the limit
is 255 chrs.

I have tried updating the Jet Database engine sp8, but message reads "the
file you are updating is newer than the file you are trying to update,
Cancelled.

Any ideas would be appreciated.

 

[John Nurick]

Hi Keith,

1) Is the file called BSEC.TXT or does it have some other extension?
IIRC you can get this problem with non-standard extensions.

2) Any field over 255 characters must be defined as a Memo field. You
can't circumvent the 255 character limit on the Text field size.

3) If you're defining the table in schema.ini, you have to change the
filename there after renaming the text file.

4) How long is the line-length of the text file? How many fields?

5) Can you import smaller and/or narrower fixed-width files
successfully?