In Clause - to query text file

[garth.waring]

Hi all

I have seen the In Clause used to remotely query a text file done but
cannot find the right syntax

The example below is for an excel file :
SELECT *
FROM [1620-1630_extract$]
IN 'C:\Reports\162 0-1630_extract.xl s '[Excel 8.0;];

There are examples in Access help but not for text files - can anyone
help???

[david epsom dot com dot au]

You can also use [database].[table] like this:

SELECT tblfx_audit.* INTO [Text;DATABASE=c :\].[mytext.txt]
FROM [tblfx_audit]
Remember, a text database is a folder, and a text table
is a text file in that database. (This is a convention
older than Access)

(david)

<ga**********@g mail.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .

Hi all

I have seen the In Clause used to remotely query a text file done but
cannot find the right syntax

The example below is for an excel file :
SELECT *
FROM [1620-1630_extract$]
IN 'C:\Reports\162 0-1630_extract.xl s '[Excel 8.0;];

There are examples in Access help but not for text files - can anyone
help???

[garth.waring]

david epsom dot com dot au wrote:

You can also use [database].[table] like this:

SELECT tblfx_audit.* INTO [Text;DATABASE=c :\].[mytext.txt]
FROM [tblfx_audit]
Remember, a text database is a folder, and a text table
is a text file in that database. (This is a convention
older than Access)

(david)

Thanks for that David

Found my examples on a disk at home

SELECT * FROM
[Text;FMT=Delimi ted;HDR=Yes;DAT ABASE=C:\Direct oryPath\;].[FileName#txt];

SELECT * INTO
[Text;FMT=Delimi ted;HDR=Yes;DAT ABASE=C:\Direct oryPath\;].[FileName#txt]
FROM TableOrQueryNam e;

cheers
Garth