SQL issue with spaces in source name
- From: Waxaholic <Waxaholic@xxxxxxxxx>
- Date: 17 Apr 2007 06:53:15 -0700
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)
.
- Follow-Ups:
- Re: SQL issue with spaces in source name
- From: Waxaholic
- Re: SQL issue with spaces in source name
- Prev by Date: Re: Writing a Decimal to SqlServer loses the fraction
- Next by Date: Re: SQL issue with spaces in source name
- Previous by thread: ConnectionString using DSN not working
- Next by thread: Re: SQL issue with spaces in source name
- Index(es):
