If file name have extra dot getting exception in C#, jet connection string template

Question

0.00/5 (No votes)

See more:

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'

What I have tried:

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'

Posted 24-Apr-17 23:14pm

ManojRGEC

Updated 24-Apr-17 23:55pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-04-24T23:23:00

Solution 1

See the documentation: Table Name Limitations | Microsoft Docs[^]

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 (`).

So try:

SQL

SELECT * FROM `sample.data.csv`

Posted 24-Apr-17 23:23pm

OriginalGriff

Comments

ManojRGEC 25-Apr-17 6:57am

Thanks for the answer, but it is not working for me. I am getting same error i.e. "The Microsoft Jet database engine could not find the object 'sample.data'. Make sure the object exists and that you spell its name and the path name correctly."

Richard MacCutchan 25-Apr-17 8:51am

Text/csv are treated differently by OLEDB, see my comments below.

Richard MacCutchan · Answer 2 · 2017-04-24T23:55:00

Solution 2

See Using OleDb to Import Text Files (tab, CSV, custom)[^].

Posted 24-Apr-17 23:55pm

Richard MacCutchan

Comments

ManojRGEC 25-Apr-17 7:05am

My file name contains a additional dot (.) as given below. I am using Oledb connection string given below.
public const string ConnectionStringTemplateJet = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=dBase IV;";

Getting error at ExecuteReader() method

_dbConnection = new OleDbConnection(connectionString);
_dbConnection.Open();
_dbCommand = new OleDbCommand(selectString, _dbConnection);
_dbReader = _dbCommand.ExecuteReader();

Richard MacCutchan 25-Apr-17 8:46am

That is not the correct way to do it. Follow the link I gave you and see how to get the proper table name from the driver.

Richard MacCutchan 25-Apr-17 8:50am

When the file is imported it will replace the dots with # characters to make the table name. So your table name will be sample#data#csv.