ERROR External table is not in the expected format when I get data from file dbf in C#

Question

My code:

OdbcConnection conn = new OdbcConnection();
conn.ConnectionString ="Driver={Microsoft dBASE Driver (*.dbf)};Driverid=277;Dbq=D:\\DBF\\";
conn.Open();
OdbcCommand oCmd = conn.CreateCommand();
DataTable dt = new DataTable();
dt.Load(oCmd.ExecuteReader());
conn.Close();
dataGridView1.DataSource = dt;

When I run to oCmd.ExecuteReader() then error: ERROR [HY000] [Microsoft][ODBC dBase Driver] External table is not in the expected format.

gunvant.k · Accepted Answer · 2014-11-26 03:21:57Z

1

You just showed your connection where your DBF file is, but didn't specified any commandText, Try something like that

oCmd.CommandText = "SELECT * FROM TableName";

answered Nov 26, 2014 at 3:21

gunvant.k

1,0861 gold badge10 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

ERROR External table is not in the expected format when I get data from file dbf in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related