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.