If file name has additional dot character like below: sample.data.csv next select statement: SELECT * FROM [sample.data.csv] with connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Data\"; Extended Properties="text;HDR=Yes;Format=Delimited;"; Getting below exception: The Microsoft Jet database engine could not find the object 'sample'
Quote:Table names can contain any valid characters (for example, spaces). If table names contain any characters except letters, numbers, and underscores, the name must be delimited by enclosing it in back quotes (`).
SELECT * FROM `sample.data.csv`
#
sample#data#csv
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)