Karen,
Mike is correct about how data is represented. However the extra padding is the
ASCII null character Hex 0 (zero). You would initially need field lengths
twice the size. You then define a computed column for each field which is
normal size with the (SRPL(colname,(CHAR(0)),NULL,1))
In my previous email re ODBC TEXT driver the example was a CSV file. Here is
info on how to specify tab delimited:
* ODBC Driver for Text
oConn.Open _
"Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=c:\somepath\;" & _
"Extensions=asc,csv,tab,txt"
Then specify the filename in the SQL statement:
oRs.Open "Select * From customer.csv", _
oConn, adOpenStatic, adLockReadOnly, adCmdText
Note: If you are using a Tab delimited file, then make sure you create a
schema.ini file, and include the "Format=TabDelimited" option.
For more information, see: Text File Driver Programming Considerations
To view Microsoft KB articles related to Microsoft Text Driver, click here
Jim Bentley
American Celiac Society
[email protected]
tel: 1-504-737-3293
----- Original Message ----
From: MikeB <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Wed, November 11, 2009 2:51:24 PM
Subject: [RBASE-L] - Re: Need help with an import filetype
Karen,
A unicode file uses Two Bytes per Character, so the phrase "Stay out of Karen's
way" would look something like:
"S t a y o u t o f K a r e n ' s w a y".
I might be able to do this using DLCall and the MultiByteToWideChar Function..
I'll let you know.
----- Original Message ----- From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, November 11, 2009 12:50 PM
Subject: [RBASE-L] - Need help with an import filetype
> I'm trying to import a file which was described to me as a "unicode text
> file", although it is saved with an .xls extension. You can bring the file
> up in Excel (it uses a tab delimiter to do it) and re-save it as another
> format, and that's what we've been doing. But they'd rather not have to do
> this. I am unable to find an import type that will bring this file in.
> Ascii tab delimited doesn't work because it is not an ascii file. This is the
> client that's still in 6.5, but I can't find anything in 7.6 either.
>
> If anyone would like to give this a shot, email me privately and I can ship
> you the file.
>
> Karen
>
