MS Access Database Publishing to SQL Server using VB.
Posted on 2001-06-22
I've made a program to Publish my MS-Access database to the SQL-Server. It converts all the properties of MS-Access database to SQL-Server database. But it is very slow due to two dimensional looping (Table-Records and Table-Fields ) and running queries to insert each record.
Is there any method to insert all the records of MS-Access database (on Lan) to the SQL Server database (on Web).
I've tried "Select.. INTO.." SQL statement (It makes the table and inserts records from one databse to another) but I don't know how to pass my SQL-Server database reference to it.
1) Please tell me the complete command based on above statement, by taking the following details -
Table-Name = Customers (All Records)
SQL-Server address = 184.108.40.2064
SQL-Server Database = MySQLDB
SQL-Server User ID = sqluser
SQL-Server Password = sqlpassword
2) Or tell me another way of pulishing (with upsizing) of MS-Access database to SQL-Server database, using Visual Basic6 and SQL queries.