I have an issue that has me completely boggled. How does one write to an Access table (or any table for that matter) other than the one you obtained the data from? I am using VS2005.
I have googled, checked other sites similiar to this one, and checked the MSDN site. I can't find anything other than populating a dataset and writing changes back to the same table.
What I am trying to do is import data from one Access table (i know... i know... but it's all they let me have) and two Excel worksheets. I then need to combine all this data into one table that will be used to produce reports.
This was so easy in vb6. You created a make table query for the Access piece, imported the worksheets, and run one more make table query to combine it all.
Any help / suggestions would be greatly appreciated!!
I have googled, checked other sites similiar to this one, and checked the MSDN site. I can't find anything other than populating a dataset and writing changes back to the same table.
What I am trying to do is import data from one Access table (i know... i know... but it's all they let me have) and two Excel worksheets. I then need to combine all this data into one table that will be used to produce reports.
This was so easy in vb6. You created a make table query for the Access piece, imported the worksheets, and run one more make table query to combine it all.
Any help / suggestions would be greatly appreciated!!