Microsoft.Jet text file query

[Simple Simon]

I'm trying to read a CSV file that happens to have some spaces in
it...(Land - Lot.csv) For some reason, the SQL statement can't find
the file...ne1?

// CSV file connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Temp;Extended Properties=\"Text;HDR=YES;FTM=Delimited\"";
OleDbConnection oleCon = new OleDbConnection(strCon);
oleCon.Open();

strSQL = "SELECT * FROM Land - Lot.csv";
OleDbDataAdapter daRead = new OleDbDataAdapter(strSQL, oleCon);
TIA,
~Gordon

[Alex Papadimoulis]

Hi Gordon,

Try using brackets around the file in the SQL Statement: [Land - Lot.csv]

Alex Papadimoulis
"Simple Simon" <re***@newsgroup.only> wrote in message
news:tm********************************@4ax.com...

I'm trying to read a CSV file that happens to have some spaces in
it...(Land - Lot.csv) For some reason, the SQL statement can't find
the file...ne1?

// CSV file connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Temp;Extended Properties=\"Text;HDR=YES;FTM=Delimited\"";
OleDbConnection oleCon = new OleDbConnection(strCon);
oleCon.Open();

strSQL = "SELECT * FROM Land - Lot.csv";
OleDbDataAdapter daRead = new OleDbDataAdapter(strSQL, oleCon);
TIA,
~Gordon

[Simple Simon]

Hi Alex,
Thxs for replying...No go :(

~Gordon

On Fri, 5 Dec 2003 16:07:21 -0500, "Alex Papadimoulis"
<alexp-at-halogenstudios.com> wrote:

Hi Gordon,

Try using brackets around the file in the SQL Statement: [Land - Lot.csv]

Alex Papadimoulis
"Simple Simon" <re***@newsgroup.only> wrote in message
news:tm********************************@4ax.com.. .

I'm trying to read a CSV file that happens to have some spaces in
it...(Land - Lot.csv) For some reason, the SQL statement can't find
the file...ne1?

// CSV file connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Temp;Extended Properties=\"Text;HDR=YES;FTM=Delimited\"";
OleDbConnection oleCon = new OleDbConnection(strCon);
oleCon.Open();

strSQL = "SELECT * FROM Land - Lot.csv";
OleDbDataAdapter daRead = new OleDbDataAdapter(strSQL, oleCon);
TIA,
~Gordon

[Simple Simon]

Wait! It does work...sorry, I forgot to update the filename in my
schema.ini file.

Thank you!

On Fri, 5 Dec 2003 16:07:21 -0500, "Alex Papadimoulis"
<alexp-at-halogenstudios.com> wrote:

Hi Gordon,

Try using brackets around the file in the SQL Statement: [Land - Lot.csv]

Alex Papadimoulis
"Simple Simon" <re***@newsgroup.only> wrote in message
news:tm********************************@4ax.com.. .

I'm trying to read a CSV file that happens to have some spaces in
it...(Land - Lot.csv) For some reason, the SQL statement can't find
the file...ne1?

// CSV file connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\\Temp;Extended Properties=\"Text;HDR=YES;FTM=Delimited\"";
OleDbConnection oleCon = new OleDbConnection(strCon);
oleCon.Open();

strSQL = "SELECT * FROM Land - Lot.csv";
OleDbDataAdapter daRead = new OleDbDataAdapter(strSQL, oleCon);
TIA,
~Gordon