SQL and Scientific Notation

Here is my sql statement:
INSERT INTO [Temp_Import] ([Item
Number],[Description],[User1],[User2],[User3],[User4],[User5],[User6],[User7],[User8])
SELECT [Item],[Desc],[u1],[u2],[u3],[u4],[u5],[u6],[u7],[u8] FROM [Large
Import.txt] IN "C:\Data\Delphi\Data\" "Text;"

The import value for Item Number is: 12345678901234567890123456789012345 and
Temp_Import is an Access table with the Item Number field being defined as a
text field 35 characters long. When I executed the sql statement I get the
following value in my Item Number field: 1.23456789012346E+34

Does anyone know why the sql statement is switching the data being read from
the text file to scientific notation?


.

Relevant Pages

  • Re: Using Like operator in VBA
    ... a left bracket [inside the bracket pair to test whether the string ... text string in a SQL statement that you would want to test for? ... If YourVariable contains any of the wildcard characters that are used ...
    (microsoft.public.access.modulesdaovba)
  • Re: Viewing the contents of two tables using ASP and MS Access
    ... Number of fields in a recordset 255 ... Number of characters in a cell in the query design grid 1,024 ... Number of characters in an SQL statement approximately 64,000 ...
    (microsoft.public.inetserver.asp.db)
  • Re: Logn line
    ... characters for a compact index. ... It still may be your SQL statement length. ... It gave the error message: ... The maximum length for a command line has been exceeded. ...
    (microsoft.public.fox.helpwanted)
  • Re: No more space on line of code?
    ... Sorry Kevin, I guess I was a bit cryptic. ... >> Access MVP ... >>> point where it will no longer accept any more characters. ... >>> as best I know the SQL statement has to be all on one line. ...
    (microsoft.public.access.modulesdaovba)
  • Re: No more space on line of code?
    ... how my code is laid out, but the problem is that the length of the first line "strSQL = ..." ... is so long that I can no longer type any more fields. ... point where it will no longer accept any more characters. ... I've pasted the SQL statement below in case there is a way to alter it to ...
    (microsoft.public.access.modulesdaovba)