Home Forums Microsoft Access Microsoft Access Issue Linking to SQL Table with too many Indexes / Appending from Access into Non-linked SQL Table RE: Issue Linking to SQL Table with too many Indexes / Appending from Access into Non-linked SQL Table

  • August 23, 2016 at 3:08 pm

    #1897053

    You could use SQL Server Management Studio to import from MS-Access.

    Connect to the SQL server, click the Databases node to expand the list, right-click on your database and select Tasks ~ Import Data which brings up the Import & Export Wizard. Select the Data source = Microsoft Access and the follow the rest of the wizard. HTH