Re: SQL and Scientific Notation


"Jeff" <jhoward@xxxxxxxxxxxx> wrote
Here is my sql statement:
INSERT INTO [Temp_Import] ([Item Number],[...] FROM [Large
Import.txt] IN "C:\Data\Delphi\Data\" "Text;"

The import value for Item Number is:
12345678901234567890123456789012345

Jeff,

Is that import value passed as a text field or number?

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

Do you mean as a 21 character text value or as a
number value?

For what it is worth, your "1.23456789012346E+34"
value is exactly how FloatToStr() formats your input
number.

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

How are you viewing the data? What is the data type
property of the TField for your "number" field?

Rgds, JohnH


.

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)