Re: Sql Insert Error


"Jeff" <jhoward@xxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:45b00276$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Do you have an example of the syntax that would be used in an SQL
statement.

Here is my sql statement.

INSERT INTO [Temp_Import] ([Item Number],[Description]) SELECT [Access
Item Number],[Description] FROM [Cubiscan data to upload2.txt] IN
"C:\Documents and Settings\jth\Desktop\" "Text;"

The Description field is the one that is getting me.
Something like this should do the trick:

INSERT INTO [Temp_Import] ([Item Number],[Description]) SELECT [Access
Item
Number],Left([Description], <put here length of Temp_ImportDescription.>)
FROM [Cubiscan data to upload2.txt] IN "C:\Documents
and Settings\jth\Desktop\" "Text;"


.