ODBC Text Driver -- Schema.INI Problem ! 
Author Message
 ODBC Text Driver -- Schema.INI Problem !

Hi Everybody,

I am using ODBC Text Driver to import text file into Database --

I need it to be imported with custom delimiter that I specify in
SCHEMA.INI --

        Format=Delimited( )

-- Simple Space.

Here is the problem : Between fields there may be several spaces.
And it messes up whole import creating unnecessary fields :(

How can I make Text driver treat those consecutive spaces as
one -- there should be some option in SCHEMA but I can't find it.

FixedLength Import is not an option bcz file fomat is always diffferent.

BTW: Is it possible to test file for field length -- then write field
length
to SHEMA and use FixedLength option for Import?

Thanks for your help,

VB5, Win95

Regards, Davie



Fri, 07 Jul 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Schema.ini With Adhoc ODBC Text File Connections

2. ODBC text schema.ini

3. Help! with Schema.ini file and ODBC text

4. ODBC /w Schema.ini and Delimited Records(:)...Problem With Double Quote

5. Text File Databases/Schema.ini Limitation

6. Can't get Text ISAM to use SCHEMA.INI

7. ADO, Text Files and that damned Schema.ini

8. Importing Text Files with Schema.ini and Execute SQL Missing first Record

9. ODBC logging feature capture nothing from ODBC.INI (16 bit drivers)

10. schema.ini and quotation marks problem

11. HELP:CRecordSet and ODBC Text Driver problem

12. Problem with ODBC Text Driver


 
Powered by phpBB® Forum Software