Re: Sql Insert Error

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.

"Bill Hannan" <wfha@xxxxxxxxxxxxx> wrote in message
news:45ae6bda$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Jeff,

Either
Set maxlength in the control you are using for input.
Or
Use leftStr in the beforepost of your ado component or when setting the
field value for a sql statement..

Bill
"Jeff" <jhoward@xxxxxxxxxxxx> wrote in message
news:45ae555a$1@xxxxxxxxxxxxxxxxxxxxxxxxx
I am getting the message "the field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less data". I really
do not want to make my text field so large just to handle a few users
incoming data that may be to large for my description field. Is there a
way around this to force it to truncate the data?

Using ADO command component and inserting into MS Access.

Thanks!





.

Relevant Pages

  • Re: Using string with unicode chars in OleDb command
    ... SQL statement in as a parameter, and then let the Command object parse the ... inserting literal constants. ... the complexities what arise in thinking out correct order of the parameters. ... but the project has to be database-agnostic, so that's why I use OleDb). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Inside SqlCommandBuilder
    ... Its after reading your article that I have these questions Bill. ... I get a sql statement that is inserting a ... NULL value into the field creationdate. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Text into Access
    ... I've already posted a number of questions on this topic and everyone has been extremely helpful. ... Is there any way to specify the field names in the SQL -- when putting the data into a new table? ... if inserting the data into an existing table do I need to have field names in the text file? ... destination table must match in order to omit the column names from the SQL statement. ...
    (microsoft.public.dotnet.languages.vb)
  • field truncated
    ... I am using the "insert database" command with an SQL statement to grab a ... I am inserting one specific ...
    (microsoft.public.word.mailmerge.fields)
  • ASP to Access DB
    ... I have a very simple script that seems to work OK inserting into an ... Access table from a CSV file. ... 'Executing the SQL Statement ...
    (microsoft.public.inetserver.asp.general)