import data files with more than 255 chars column | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

import data files with more than 255 chars column

Hi there,
could anyone give me a method of loading a data file with coulumns longer than 255 chars to a sql database? ( or Access database, for Access not to use the link method though).
I mean without programming. ( can be bcp, dts etc.) thanks!

If your destination field is longer than 255, I don’t see any issue using DTS.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
ok Luis, you are right. for SQL Server, I only need to reset QA’s option (I thought it was truncated though and I couldnot believe it!).
how about Access? does Access 2000 still truncates 255 columns? thanks!

ok. I used DTS to transfer the table ( which I imported from the data file ) from sql to Access and it worked. thank you all!