Forums

This topic is locked

Using .txt as an ODBC Data Source

Posted 09 May 2002 04:39:44
1
has voted
09 May 2002 04:39:44 Jason Rednour posted:
I have created a connection to an ODBC Data Source that is a folder with two text files. The connection tests successfuly and each of the files is listed in the table drop down box with the word "null." in front of the file name. When I choose the file I want to use, the data from the first row of each column is displayed in the columns box. However, when I test the recordset object I get an error that says "Micorosoft Jet DB Engine cant find object null.filename.txt"

Can anybody help?

Replies

Replied 10 May 2002 18:26:13
10 May 2002 18:26:13 Andrew Watson replied:
Look at your recordset code....

see the bit that says null.filename.txt

try changing this to YourDBFolderName/filename.txt

This should work, let me know as its weird...

Cheers
Leed

:: Son, im Thirty.... ::

Reply to this topic