How do I copy an Excel column name to a string using OLEDB with C#? [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 10 years ago.

Improve this question

Rookie here... I need to get the column name from an excel file so I can use it as a string. I'm using C# with OLEDB.

private void CheckFiles();
{
    OleDbConnection MyConnection;
    DataSet DtSet;
    OleDbDataAdapter MyCommand;
    string file = @"C:\Users\...path...\2015.xlsm";
    MyConnection = new OleDbConnection(@"provider=Microsoft.ACE.OLEDB.12.0;Data Source='" +
                            file + "';Extended Properties=Excel 8.0;");
    MyCommand = new OleDbDataAdapter("Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = " + 
                            tab, MyConnection);
    MyConnection.Open();
    MyCommand.TableMappings.Add("Table", "Net-informations.com");
    MyConnection.Close();
}

Thanks in advance!

sounds really good that you are using C# with OLEDB now show us what you have thus far so that we can help or someone else can lend you more advice. post your code showing us what you have tired... — MethodMan
– MethodMan, Commented Oct 6, 2015 at 2:23
@MethodMan I'm so new to this that I couldn't tell if you're being sarcastic... hehehe... anyway, I don't have much... I added the code I have so far to the original post. Thanks! — ElPeta
– ElPeta, Commented Oct 6, 2015 at 2:39
you need to use the Fill method to execute the OleDbAdapter sql command.. I will post an example on how I just tested excel on my own machine using JetProvider — MethodMan
– MethodMan, Commented Oct 6, 2015 at 2:49

MethodMan · Accepted Answer · 2015-10-06 02:51:38Z

0

string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 12.0;";

ConnectionString = string.Format(ConnectionString, @"FullPathToExcelFile"); //my path replace with your actual file path

OleDbConnection conn = new OleDbConnection(ConnectionString);
conn.Open();

OleDbCommand cmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);
OleDbDataAdapter oleDBAdapter = new OleDbDataAdapter();
oleDBAdapter.SelectCommand = cmdSelect;

DataSet myDataset = new DataSet();
oleDBAdapter.Fill(myDataset);
conn.Close();

answered Oct 6, 2015 at 2:51

MethodMan

18.9k6 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I copy an Excel column name to a string using OLEDB with C#? [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related