By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,806 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,806 IT Pros & Developers. It's quick & easy.

Selecting from Text File Truncates Long Strings

P: n/a

I am selecting data from a text file in the following format:

INSERT INTO [LockBox Info] SELECT * FROM " & sSource & " IN '' " & _
"'text;Database=" & sPath & ";FMT=Delimited;HDR=No' " & _
"WHERE [Record ID] = '01'"

Variable names are used for the file name, etc. But the problem lies
in the "SELECT *". We have strings that are larger than 254
characters that are cut off during this process. Is there a character
limit in selecting data from text files? And if so, is there a way to
expand this limit?

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.