September 2, 2009 at 1:03 am
Greetings All.
I would really appreciate any input on the following problem.
I am trying to use the bcp utility, to import numeric data created by a DOS application, into an SQL Server 2005 table. The problem seems to be that the data which I want to import, was created using the Single data type in GWBASIC, (32 bit Floating Point), which, when you look at it internally with a HEX editor, is stored in reverse byte order. (I think this is referred to as little-endian).
Is there a way, using bcp, or any other method such as BULK INSERT perhaps, which this type of data can be imported, without the need to write a specialised application.
Many Thanks
September 3, 2009 at 12:32 pm
bcp was designed to be quick and simple. It works extremely well if all the data in in character format - the default.
I have used it to bring in Access data, Sybase data, Oracle data and even DB2 data - so long as it is in 'display' numeric format.
My suggestion is that you modifiy the process creating the bcp input file to put out 'display' data as opposed to binary numeric data. In the long run you will save yourself a lot of headaches.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply