Home Forums SQL Server 2008 SQL Server Newbies Import records in MS Access table to native SQL Server 2008 table RE: Import records in MS Access table to native SQL Server 2008 table

  • Hi Ryan, thanks for responding.

    I downloaded the 64-bit version of the package you mentioned. Before installing it, however, I decided to retry the import - which worked!! Very good, but Why?

    Possible contributing factors... I noticed the the SQL server agent service was stopped, so I started it - how long it had been like this I don't know. But why would the agent be needed for running an import immediately, as I chose to do? I thought it was just for scheduling backups etc.

    Also, in the wizard, there are places where you select more advanced options. After the first failure, I went into these and OK'ed out of them, but didn't alter anything.

    When I deleted the imported table and retried the import, it failed again, twice, with SQL server agent running, so it probably wasn't the agent after all.

    It eventually succeeded again, after I retried going through the steps, but this time at the Choose Data Source stage I clicked on Advanced, then clicked the Connect, Advance and All tabs, then OK'ed back out and carried on with subsequent steps.

    This seems to be how to get it working, but again - why? Flaky, I call it. Brilliant though, I'm sure, in many ways...

    Mark Dalley