ODBC Text Driver
| From: | USA) | Date: | Tue, 07 May 2002 20:46:37 +0000 |
| Subject: | ODBC Text Driver | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19029@lists.php.net to get a copy of this message | ||
Has anyone had any luck querying a tab delimited text file using odbc?
I'm certain I'm doing it wrong but here's what I tried on an odbc connection:
select * from [myfile.csv]
And I got...
Warning: SQL error: [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected to the server on which the
file resides., SQL state S1009 in SQLConnect in
Thanks!
<>< Ryan