Re: SQL and Scientific Notation
- From: "Vassiliev V. V." <support@xxxxxxxxxxxxxxx>
- Date: Sat, 27 Jan 2007 01:32:47 +0300
Do you have schema.ini file in C:\Data\Delphi\Data? If not, add it and
define format of LargeImport.txt file there. Look
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp
for format of schema.ini.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Jeff" <jhoward@xxxxxxxxxxxx> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
news:45ba4caa$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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?
.
- References:
- SQL and Scientific Notation
- From: Jeff
- SQL and Scientific Notation
- Prev by Date: Re: SQL and Scientific Notation
- Next by Date: Re: DAO to ADO and stored procs
- Previous by thread: Re: SQL and Scientific Notation
- Next by thread: Re: SQL and Scientific Notation
- Index(es):
Relevant Pages
|
