excel import CSV

[spranks]

Gurus,

I am trying to import CSV file (s) into excel using a VBA macro. and
it looks like excel truncates my data to 255 characters per cell. I
understand that this is an excel limit.

Is there any way to work around it / sove it ?

any help greatly appreciated.

thanks in advance

 

[Phil Smith]

What the heck are trying to load into a single cell that is more that
255 characters? I would suggest you import it into access and modify it
to something reasonable.

 

[spranks]

well, strings..really long strings

unfortunately, i don't have the luxury to move to access..atleat for
now. ( its a app used by lot of perople in the company..mostly non
techies) so Whatever i have to do , i have to do it in excel.

 

[John Nurick]

Hi Spranks,

If you look in Excel Help under "Excel specifications and limits" you'll
find that (in modern versions) a cell can hold up to 32767 characters.
So the problem is in your VBA code.

The fact that you describe this as "a VBA macro" makes me think you're
working in Excel and not Access. Even if not, you're presumably writing
code that manipulates Excel. So you're much more likely to get a good
answer if you post in an Excel programming newsgroup.