txt file contains to much fields

[dro]

I've got a txt file with approx. 255 fields. The file was created by
filling in and saving data within a form in Word.
I need the txt file to be imported in Access 97. As there is a max of
49 fields you can see I've got a tiny problem to overcome.

Is there anyone out there who knows how to deal with this problem?

Cutting my form into 5 different forms with 49 fields is not an option.

 

[John Vinson]

I've got a txt file with approx. 255 fields. The file was created by
filling in and saving data within a form in Word.
I need the txt file to be imported in Access 97. As there is a max of
49 fields you can see I've got a tiny problem to overcome.

Is there anyone out there who knows how to deal with this problem?

Cutting my form into 5 different forms with 49 fields is not an option.

Well... a Form doesn't contain fields, and isn't a storage medium for
data. It's a tool to display data from a Table.

You can use File... Get External Data... Link to link to a text file
with 255 fields (but that's the absolute unbreakable maximum limit).
I'd strongly suggest that you consider normalizing your data - I've
needed as many as 60 fields in a table, once or twice; 255 is
emphatically NOT normalized! Given a properly normalized set of
tables, you should be able to run append queries from the linked text
file and then display the contents of the tables on your form.

 

[Brendan Reynolds \(MVP\)]

I'm not sure where the number 49 is coming from? The maximum number of
fields in a table is 255, I don't remember the maximum number of controls on
a form exactly, but it's in the hundreds - somewhere between 700 and 800 if
I remember correctly.

You say there are 'approx' 255 fields. The first thing to do is to eliminate
the 'approx'. You need to know for sure whether there are more than (even
one more than) 255 fields. If there are 255 fields or less, you can, if you
prefer, import them all into one table and then use either code or action
queries to distribute them to the appropriate normalised tables within
Access. If there are more than 255 fields, then you'll need to do your
importing in code, and distribute the fields to the appropriate normalised
tables as part of the import process.