Import limitations on table fields?

[VBAhole22]

I am trying to import to a table in Access from a comma-delimited text file that has about 250 fields of data in it. For some reason it keeps cutting off a large chunk of fields at the end. Is there a cap on the number of fields you can import into Access? Excel behaves similarly. SQL Server could import the whole thing but then when we try to pull it into Access it gets cut at the same field consistently. We have looked at the text file and there is nothing peculiar about that one field. We have imported it into Access from SQL Server in a series of steps but it takes more than 2 steps. It seems to me there is a cap but I have never read about it before. Any suggestions?

 

[crosmill]

I think the cap (certainley for excel) is 255 or 256, I think Access also has this limit for the number columns your allowed per table???

Personally I'd use SQL Server if your dealing with anything that big, otherwise you'll have to break the table up!