Need More than 255 Fields

[mbogan]

I have a text database with | as the delimiter. There are 715 records, with 311 fields. When I import it in to Access It stops the import at 255, I know that a relational database would make sence, however, I cannot manipulte the text file unless I get it into either access or excel. Is there a way to get this to work??

Please help, I have a serious deadline to contend with.

 

[mdmilner]

Big problem.

Is it possible to change the text file, Possibly by dividing it into two portions each using the same unique keyfield as an index?

There may be a better way, but the only thing that comes to mind is for you to open the file as input and read each line then parse it. During the parse operation you'd identify and update two or more related tables to create your records.

Mike