Access files of different formats are imported into the Mssql database.

So far, there have been two Access file formats, one being mdb files, and the other being Accdb files. They have different Chinese methods for importing them to the Mssql database.

1. Import in Mdb format:

SELECT * into newtab from openrowset (''microsoft. Jet. OLEDB.4.0 '', ''C: database. mdb''; ''admin''; ''', link)

GO

Microsoft. jet. OLEDB.4.0 is an ODBC driver and C: database. mdb is the physical path of the Mdb file to be imported. In particular, it indicates that the file to be imported must be uploaded to the server where the database is located, and Link is the Access table name.

2. Accdb format import:

SELECT * into newtab from openrowset (''microsoft. Ace. OLEDB.12.0 '', ''C: aa. Accdb'; ''admin''; ''', bb)

GO

Microsoft. Ace. OLEDB.12.0 is the ODBC driver number, C: aa. accdb is the physical path of the accdb file, and bb is the accdb table name.

3. Compatibility:

The Microsoft. Ace. Oledb.12.0 driver is fully compatible with the Microsoft. Jet. Oledb.4.0 driver, and vice versa. For example, you can use Microsoft. Ace. OLEDB.12.0 to import Mdb files.

Select * into newtab from Openrowset (''microsoft. Ace. Oledb.12.0 '', ''C: database. mdb''; ''admin''; ''', link)

 

<