Access Character Limit Per Row Help

[JJ Smokes]

Hi Guys,

You all were able to help me before, so here goes!

I am importing a .CSV file into Access 2007 with 100+ fields and 15,000+ records. While importing, Access errors out and says one of my rows exceeds the 65,000 character limit, and thus crashes the import. Because Access will not open the file to tool around with it, does anyone know an easy way to figure out which of these records exceeds the limit so that I can delete it?
Thanks in advance,
JJ

 

[KenHigg]

See if something like this may help:

http://www.access-programmers.co.uk/forums/showthread.php?t=147267

Kind of looks like the same issue...