> 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.

>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...
> ...

> 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");
> ...