Having another brain fart on what I believe is a no brainer.
I'm trying to read the contents of a DBF and write it to an ACCDB table; this is a daily event and the DBF has between 500-1200 records each day.
I have successfully read the contents of a DBF table and filled my da.Fill(ds, "Data") with it along with a DataGridView.
Now I want to write the entire table with NO parameters to my ACCDB Table 'BlahBlah'; both structures are the same. I see a ton of samples & examples WITH parameters, but no cmd.command INSERT examples to insert/copy everything.
Basically I want to: INSERT INTO [BLAHBLAH] SELECT * FROM ds.tables("data") ....something like that
Everything related to the connection string, data source, etc is fine; I've been using it for other procedures with no problems.
What I can't seem to get is:
- the INSERT statement
- whether I loop through the datatable row by row, or can copy thr whole thing in one blast
Appreciate someone's guidance and patience :)