because I didn't want to hard-code the text parser myself, I just
wanted to use the MS-Text driver or maybe the BDE ASCIIDRV

eventually I gave a try to ODBC, so I set up an ODBC-datasource with
properly defined fields and their formats,
this worked well with excel and so on...

my problem is that database desktop / sqlexplorer does not recognize
any of the fields and their corresponding format definitions I made in
this ODBC datasource,

I can see  the tables in SQL explorer but if I try to select one of
them it says 'Invalid Tablename' and no field definitions are
available

Do I really have to fall back to a hard-coded import routine or is
there any way to get ms-text driver working with the bde ?

any help is greatly appreciated

[TABLE1]
FileType=Fixed
;or
FileType=delimited
;lang driver
CharSet=ANSIINTL

Delimiter="
Separator=,
;follow the fields in format:
FieldXX=<Name>,<type>,<length>,<decimals>,<line offset>
Field1=K_STATUS,Char,01,00,00
Field2=Name,Char,10,00,01

If you allready have a table with that structure (in msssql), you can borrow
structure from it and let BDE create the schema file for you:
  TextTable.FieldDefs.Assing(mssqltable.fielddefs);
  TextTable.CreateTable;

For more info search borland site for TI about ascii files.

--
----------------------
Regards
Robert Cerny
Remove both qwe when replying

No questions via email, unless explicitly invited.