Author: DDD Date: Mar 9, 2008 10:31
On Feb 28, 9:22 pm, gibbonas discussions.microsoft.com>
> 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
> 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");