Can't connect csv/txt file to Table1

[BBMtnMan]

Connecting .mdb, .db, & .dbf with ODBC and then using them with TdataSource, TTable, and TDBGid is straightforward. But when I connect .txt/.csv files with ODBC and then try to attach them to Table1, I get 'DBE Error 10039 27 37 Invalid table name.' Of course, I have renamed the table (and the file) to everything under the sun. I have tried the procedure in Builder 5 and Builder 6, win 98, win2000pro, and XP pro. Still, no joy.

What is the trick?

 

[abzupfer]

The BDE calls SQLTables to determine whether a table name exists. The BDE does not expect table names returned by SQLTables to have an extension, but Microsoft's Text driver does include extensions (Because unlike other drivers, it allows for tables with different extensions within the same database.) and therefore the tablename cannot be verified.
There are two possible workarounds to the problem: . Use text files without extensions. To configure Microsoft's ODBC Text driver to do this run ODBC Administrator, configure your DSN, click Options, and *. as an extension. 2. Use the BDE Native Text driver instead.

 

[abzupfer]

Found this in another forum,
however it doesnt work, just produces another error.
It says now the file is write protected and cant be updated.
Sorry...

 

[abzupfer]

ok heres sth else:

It seems Borland can't connect with a TTable. It works if you connect the DataSource via a TQuery object with sth like
"select * from t1.txt".

from

http://www.elists.org/pipermail/delphi-talk/1999-August/000611.html