Software

Ask something
Question Locked

Using Visual Studio 2005

0 helpful
6 replies

by bdelacruz246

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi Everybody,

Does anybody know how to move an Access table from one database to another using VB in Visual Studio 2005? Below is the code that I used. Both the arrTable object array and the copyTable datatable does not work. It copies the object to the dataset but it does not save it to the other database that is the source of that dataset. Any help would be really good. I have been stuck with this code for more than a day now.

Dim table As DataTable
Dim copyTable As DataTable
?Dim arrTable(25) As Object
Dim x As Integer = 0
Dim z As Integer = 0

Dim item As ListViewItem
Dim checkedItems As ListView.CheckedListViewItemCollection = _
ListView2.CheckedItems

Try
For Each item In checkedItems
arrList(z) = item.SubItems(0).Text
z = z + 1
Next

myConnectionSource = New OleDb.OleDbConnection(strConnectionSource)
myConnectionSource.Open()

For Each table In CoaSfaDataSet2.Tables
If arrList(x) = table.TableName Then
?arrTable(x) = table.Copy()
copyTable = table.Copy()
CoasfaDataSet.Tables.Add(copyTable)
x = x + 1
z = z - 1 : If z = 0 Then Exit For
End If
Next table

myConnectionSource.Close()
myConnectionSource = Nothing

Catch
MsgBox("Cannot proceed! {0}." + e.ToString(), MsgBoxStyle.OkOnly, "NOT SUCCESSFUL")
End Try

6 replies

by scott_heath

Tried using the Microsoft Access COM Objects in your project? If you want to move it as an object instead of using SQL, this is where I would start. MSDN will have lovely descriptions of what everything does.

by bdelacruz246

how to add a reference to that from VS 2005. I searched the MSDN site and could not find the link. Thank you for taking the time to answer my question. I will definitely look into this.

by scott_heath

Have office installed? When you add a reference click on the COM tab and scroll down to Microsoft Access XX Object Library.

And you are right MSDN doesn't have easily accessible docs on this. Basically you can create a new instance of the Access app using Microsoft.Office.Interop.Access.Application then go from there.

I would just use SQL though, it's probably going to be easier.

by bdelacruz246

I added a reference to Interop.Access and it is not easy at all. I searched and could not find a way to move or copy one table from one database to another. Thank you so much for your help though. I'll go with the SQL, but I will still keep on trying to learn more about adding and using the references.

by scott_heath

Because Microsoft normally documents so well on MDSN.

They do offer a book on programming Office in .NET, but I have no idea if it would even cover what you need.

This discussion is closed to new replies.