§ character as a field delimiter

D

dan.t.matthews

Hope someone can enlighten me, I am trying to use the '§' as a field
delimiter but the driver throws an error (.. 'the Format option is
invalid....') which I assume means it doesnt like that character as the
delimiter.

Is there a way of getting this to work or am i stuffed!?!?!?!?

I find this rather annoying since the documentation specifies that
*any* character may be used [except a double quote] and doesnt mention
any other caveats or work-arounds...

TIA,
dan
 
J

John Nurick

Hi Dan,

In what context are you trying to use § as a field delimiter (separator?)
and how are you specifying it? - importing or exporting, via the text
import/export wizard, in an Access import/export specification, in
schema.ini...?


Hope someone can enlighten me, I am trying to use the '§' as a field
delimiter but the driver throws an error (.. 'the Format option is
invalid....') which I assume means it doesnt like that character as the
delimiter.

Is there a way of getting this to work or am i stuffed!?!?!?!?

I find this rather annoying since the documentation specifies that
*any* character may be used [except a double quote] and doesnt mention
any other caveats or work-arounds...

TIA,
dan
 
J

John Nurick

I've haven't been able to test this properly, but so far the only way I
can provoke an error 3442 "...the Format option is invalid" is by
enclosing the delimiter in quotes, e.g.
Format=Delimited("§")
instead of
Format=Delimited(§)


Apologies, in the schema.ini ............

John said:
Hi Dan,

In what context are you trying to use § as a field delimiter (separator?)
and how are you specifying it? - importing or exporting, via the text
import/export wizard, in an Access import/export specification, in
schema.ini...?


Hope someone can enlighten me, I am trying to use the '§' as a field
delimiter but the driver throws an error (.. 'the Format option is
invalid....') which I assume means it doesnt like that character as the
delimiter.

Is there a way of getting this to work or am i stuffed!?!?!?!?

I find this rather annoying since the documentation specifies that
*any* character may be used [except a double quote] and doesnt mention
any other caveats or work-arounds...

TIA,
dan
Click to expand...
Click to expand...
 
D

dan.t.matthews

Hi Jihn, this is my (programmatically-generated) schema:

[l43.txt]
ColNameHeader=False
Format=Delimited(§)
MaxScanRows=0
CharacterSet=ANSI



I cant see anything obvious!!!

Any wisdom much appreciated!
Cheers,
dan
 
J

John Nurick

Mysterious. I'll try to investigate further over the weekend.


Hi Jihn, this is my (programmatically-generated) schema:

[l43.txt]
ColNameHeader=False
Format=Delimited(§)
MaxScanRows=0
CharacterSet=ANSI



I cant see anything obvious!!!

Any wisdom much appreciated!
Cheers,
dan
 
D

dan.t.matthews

Hi John

Did you ever get a chance to test this as I still get this problem and
need to come up with a solution!!??

Cheers,
dan
 
J

John Nurick

Sorry, Dan. Things have been really hectic in the day job. Once I've
caught up on some sleep....

Hi John

Did you ever get a chance to test this as I still get this problem and
need to come up with a solution!!??

Cheers,
dan
--------------------------------------------------------------
John said:
Mysterious. I'll try to investigate further over the weekend.


Hi Jihn, this is my (programmatically-generated) schema:

[l43.txt]
ColNameHeader=False
Format=Delimited(§)
MaxScanRows=0
CharacterSet=ANSI



I cant see anything obvious!!!

Any wisdom much appreciated!
Cheers,
dan
Click to expand...
Click to expand...
 
G

Guest

Is § (high bit character) compatible with ANSI (no translation)?
What happens if you try OEM?

(david)




Hi Jihn, this is my (programmatically-generated) schema:

[l43.txt]
ColNameHeader=False
Format=Delimited(§)
MaxScanRows=0
CharacterSet=ANSI



I cant see anything obvious!!!

Any wisdom much appreciated!
Cheers,
dan
 
Top