Microsoft Text Driver with ADO to import CSV files
Posted on 2006-05-08
I am trying to import CSV files with the microsoft text driver.
I am using TAdoConnection and TAdoTable.
The following code works fine:
Connection.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\;Extended Properties="text;HDR=No;FMT=Delimited";Persist Security Info=False';
except when I try to use a file that is not in "C:\". My files are in a nested directory such as "C:\up\Br\08052006-110551\". If I change my datasource in the connection string to "C:\up\Br\08052006-110551\" then I get a message saying "syntax error in from clause"
How do I sort this out?