Post reply

Importing into Access

  • December 17, 2003 at 11:49 am

    #107120

    I need to import data into an access database on a weekly basis. Each week I need to create a new table with a with a time stamp in the name. What is the best way of doing this dynamically in the DTS Package?

  • December 18, 2003 at 9:24 am

    #486982

    If you are going to do this in DTS you will:

    1. Create

    a) Access DB Connection

    b) Execute SQL Task

    c) ActiveX script Task

    2. Make Workflow(on complete) starting From ActiveX to the Execute SQL Task

    3 on the ActiveX get current date and change the SQLStatement Property of the Execute SQL task as CREATE TABLE YOURTABLENAME (field1 type, ...)

    HTH


    * Noel

  • December 18, 2003 at 9:34 am

    #486985

    Thanks for your help.

    Actually this is exactly how i figured it out. The hard part is determining Object names, but Disconnected edit really helps out in this section.

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

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