Post reply

Import MS Access Table to SQL 7

  • August 1, 2005 at 3:03 am

    #167825

    Hi Everyone,

    I was wondering if it is possible to directly import a MS Access Table to SQL 7  via code in Visual Basic and SQLDMO?

    If so, could you please give an example?

    Thanks for your time!

  • August 1, 2005 at 10:06 am

    #578598

    Why bother with VB or SQLDMO when Enterprise Manager will do it for you?

    Right click table in EM.

    All Tasks --> import data.

    The wizard will priactically do it all for you.

    And, you can save the package to edit in DTS if you want to reuse it.

    Sara 

     

  • August 1, 2005 at 7:59 pm

    #578710

      I need to use SQLDMO because that is not the only task that I'm doing. Basically, I will be doing some importing exporting and column manipulations. I understand that it will be easier to do it using enterprise manager but was wondering if there is a "cleaner" way to do it using SQLDMO and reduces the user intervention.

  • August 2, 2005 at 8:18 am

    #578850

    You can create a sp in sql server to import the data using t-sql or DTS package. Then you can call this sp from Access using an OLEDB connection. I haven't used SQLDMO so I don't know how that works.

  • August 2, 2005 at 3:17 pm

    #578974

    Another option is to  create the import and transformations in a DTS Package, then save as a VB .bas file, then build an interface around it.

Viewing 5 posts - 1 through 4 (of 4 total)

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