large comma delimited file

[exactajack]

is there a way to import a file larger than 255 fields into access 2002

 

[SydneyGeek]

Not into one table -- the limit is 255 fields (see this link for Access specifications).
You'll have to work out a way of splitting the data into 2 or more tables, importing them, and re-compiling the data in Access as you need it.

How often will you be importing the data, and how often will it change? Thsi will impact how you might handle the problem.

Denis

 

[Joe4]

If your table has over 255 fields in it, it is very likely that it may not be Normalized, which could cause other problems in using the data (depending on the level of complexity of your database).

I would recommend trying to normalize the data a little more before importing it (which will probably have to be worked out with whoever is providing the data).

There should be some links out there on how to Normalize your data. If you need help finding those links, please post back.