Continue through the wizard and hit finish to begin the import.
Select the tables you want copied and edit the mappings if needed. Select “Copy data from one or more tables or views”. Enter your SQL credentials and select the database you wish to import the data to, the database should show up in the dropdown menu if your MS SQL info is correct. Enter the MS SQL server name or choose from the dropdown menu. For the “Data Destination” choose “Microsoft OLE DB Provider for SQL Server”. Under login information, choose a blank username and be sure to check “Blank Password”. Click “Properties” enter the location of the. For “Data Source” choose “Microsoft Office 12.0 Access Database Engine OLE DB Provider”. Open MS SQL Server Import and Export Wizard. Open the *_be.accdb file that was created to gain access to the database tables. Follow the wizard to split the database. 
In Access 2013 in the database tools tab click the “Access Database” button under “Move Data”.
0 kommentar(er)
