Extra ' in excel, please help
Hi all,
When I use:
objDB.Execute _
"SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _
"].[" & strWorksheet & "] FROM [" & strQuery & "]"
I get an extra single quotation mark (') at the begining of every post in Excel. Does anyone know why and how I can get rid of it?
Thanks in advance
Gustav
Hi all,
When I use:
objDB.Execute _
"SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _
"].[" & strWorksheet & "] FROM [" & strQuery & "]"
I get an extra single quotation mark (') at the begining of every post in Excel. Does anyone know why and how I can get rid of it?
Thanks in advance
Gustav
Last edited: