Post reply

Import access database

  • September 24, 2014 at 9:55 am

    #293534

    Hello, I need to create a job that import an access database.

    Does exist a command that I can use to do that?

    Thanks

    Viky

  • September 24, 2014 at 10:34 am

    #1747901

    One way would be to create a stored procedure to do the import/massage of data and then schedule that in a Job. Then if the Job executes on an interval, then the data would get imported on that. Without more information, it's hard to give you a more definitive answer. You could use OPENQUERY or something to get to your Access data.

  • September 24, 2014 at 11:22 am

    #1747927

    sistemas_casinomnes (9/24/2014)

    Hello, I need to create a job that import an access database.

    Does exist a command that I can use to do that?

    Thanks

    Viky

    Quick thought, I've found that using the import/export wizard to create an SSIS package, saving it and modify as needed, being the path of least resistance. The package can then be run by a scheduled job.

    😎

  • September 24, 2014 at 1:38 pm

    #1747966

    Very true... I was probably having flashbacks to "databases" created by people that didn't have a clue what they were doing... so a LOT of cleanup was required... in that case, SSIS definitely gets my vote.

  • September 25, 2014 at 4:51 am

    #1748092

    What is the command Transact sql that I can use to import the access database?

  • September 25, 2014 at 9:41 am

    #1748234

    Is this a one time thing? Does the destination database and the tables already exist in the destination? SSIS could do it. Not enough details to know which is the best option though.

  • September 26, 2014 at 5:10 am

    #1748436

    Yes the database and destinations tables already exists.

Viewing 7 posts - 1 through 6 (of 6 total)

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