Create a new SQL DB then copy tables and data from MS Access DB

  • Hi,

    I'm looking for some advice and to find out if the following is possible.

    I have an Access DB that get's updated each week, In order to improve our reporting, I'd like to create a new SQL DB each week, with a copy of the Access DB tables and it's data. I want to automate this, and feel PowerShell could be the answer.

    It feels fairly straightforward to do something like this, but is it possible in PowerShell, and is it as easy as it sounds?

    Any help or guidance to point me in the right direction to start this, is much appreciated.

  • Does the schema of the Access DB also change much?

    If not, it would be better, in my opinion, to build a process to refresh the data in your SQL Server database every week, using the updated Access DB as the data source.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply