SQL syntax error -
11-23-2004
, 12:10 PM
When using an OleDbCommand object to attempt to import a CSV text file,
I get a syntax error in the from clause.
I can access the same text file like yay:
__connection str__
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\import;Extended
Properties=Text
__query__
SELECT * FROM [import.txt]
Here is the offending SQL:
SELECT * INTO [TempTable] FROM [Text;DATABASE=f:\import].[import.txt] |