SQL issue with spaces in source name

[Waxaholic]

I am using the following statement and have run into a problem when
trying to bring in a column with a space in it. I have tried using the
recommended "[" and "" double quotes but it still complains. Here is
the code.

"SELECT TIP " & _
",POS_NBR " & _
",POS TITLE " & _
"FROM " & GetFileName(FileName) & ".csv",
strConn)

 

[Waxaholic]

Sorry. I accidentally posted without finishing. Anyhow, the code fails
on POS TITLE. I cannot change the source data so am stuck dealing with
this. Does anyone know of a creative way around this?

Thanks

 

[Daniel A. Seara]

Try this
"SELECT TIP " & _
",POS_NBR " & _
",[POS TITLE] " & _
"FROM " & GetFileName(FileName) & ".csv",
strConn)

 

[Waxaholic]

The brackets do not work. Double Quotes do not work either.

Try this
"SELECT TIP " & _
",POS_NBR " & _
",[POS TITLE] " & _
"FROM " & GetFileName(FileName) & ".csv",
strConn)

Sorry. I accidentally posted without finishing. Anyhow, the code fails
on POS TITLE. I cannot change the source data so am stuck dealing with
this. Does anyone know of a creative way around this?

Thanks

 

[Earl]

I think you have an underline between POS and TITLE.

The brackets do not work. Double Quotes do not work either.

Try this
"SELECT TIP " & _
",POS_NBR " & _
",[POS TITLE] " & _
"FROM " & GetFileName(FileName) & ".csv",
strConn)

Sorry. I accidentally posted without finishing. Anyhow, the code fails
on POS TITLE. I cannot change the source data so am stuck dealing with
this. Does anyone know of a creative way around this?

Thanks

 

[Guest]

Try using a schema.ini file. I know you can use double quotes around the
filename then.