SQL Server Performance Forum – Threads Archive
import data files with more than 255 chars columnHi 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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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!