Launch Microsoft Access. Choose "File" and pick the "Blank Database" icon. Enter a filename and select "Create" to create a new database. Obtain the Microsoft SQL Server connection information ...

Upsize data to SQL Server by creating an entirely new database on SQL Server without making changes to the actual MDB file. Access provides all the tools you’ll need for all three solutions ...

With VB6, you can call ADODB objects to open an SQL database connection, send a query and then store the results in a Recordset data object. Open your text editor and create a file named "vb_sql.vb".