Hi all,



I am importing from a text file using the following statement:

SELECT * FROM
[Text;FMT=Delimited;HDR=Yes;DATABASE=C:\DirectoryPa th\;].[FileName#txt];

I want to set the delimiter of the file, for instance a semicolon, and I do not know how to do it. I have tried with the following statements, but without good results.

1. SELECT * FROM
[Text;FMT=Delimited(;HDR=Yes;DATABASE=C:\DirectoryPa th\;].[FileName#txt];

2. SELECT * FROM[Text;FMT=Delimited";";HDR=Yes;DATABASE=C:\Director yPa th\;].[FileName#txt];

Any advice will be very helpful.

Thanks in advance,

Felipe.