OleDbCommandBuilder insert query will not work? dataset to Access
- From: gibbonas <gibbonas@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Feb 2008 05:22:01 -0800
I am trying to take a very strangely delimited text file and put it into
access. So far I was able to get the text file into a dataset and figured
from there I could get it into access. I am trying to use the code below but
the insert query just will not work. I am working with a blank access
database and I am able to get the table and the field names in the
database(with a primary key). I just cannot get the rest of the data. I get
an error that there is incorrect syntax in the insert query. Can someone
please help! I've been all over the site reading a buch of different things
and tried to just write inserts for each row but cannot get that to work
either.
Thank you!
DataSet result = new DataSet();
....get delimited file into dataset...
OleDbConnection DB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=c:\\Conversions\\" + agencyid + "\\" + agencyid + ".mdb");
OleDbDataAdapter DataAdapter = new OleDbDataAdapter();
DataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM " + TableName,
DB);
OleDbCommandBuilder CmdBuilder = new OleDbCommandBuilder(DataAdapter);
DB.Open();
DataAdapter.FillSchema(result, SchemaType.Source, TableName);
DataAdapter.InsertCommand = CmdBuilder.GetInsertCommand();
//I added the line above because the insert query did not show in the data
adapter.
//It now has: insert into tablename(fieldname1,fieldname2...) Values
(?,?,?...)
DataAdapter.Fill(result, TableName);
DataAdapter.Update(result, TableName);//Fails here on the insert query
DB.Close();
.
- Follow-Ups:
- Re: OleDbCommandBuilder insert query will not work? dataset to Access
- From: Stephen Howe
- Re: OleDbCommandBuilder insert query will not work? dataset to Access
- Prev by Date: Re: DBNull inside DataTables... errors.
- Next by Date: Re: OleDbCommandBuilder insert query will not work? dataset to Access
- Previous by thread: DBNull inside DataTables... errors.
- Next by thread: Re: OleDbCommandBuilder insert query will not work? dataset to Access
- Index(es):
Relevant Pages
|
|