Unanswered: how to export Access mdb to Sql database....
I have a mdb in Access named test1.mdb with tabale named test_table and a Db Sql test2.mdf with tabale named test_table.
Each table of database have the same name fileds: prova1, prova2, prova3...prova20.
Now with vba or vb classic is possible to transfer the data from Access .mdb into Sql table, Record by Record
prova1 from .Mdb to Prova1 slq table
prova2 from .Mdb to Prova2 slq table
prova3 from .Mdb to Prova3 slq table
prova20 from .Mdb to Prova20 slq table
Tks to all.
I use this code to pass dta with excel and inseted Excel i would want to use access mbd to sql table...
In effect import into sql databse record by record from access mdb....
Dim Cn As ADODB.Connection
Dim Server_Name As String
Dim Database_Name As String
Dim User_ID As String
Dim Password As String
Dim SQLStr As String
Dim rs As ADODB.Recordset
Dim RowNo As Long