Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    15

    Unanswered: SQL Server Export

    Is it possible to Automate Data Export of a table with Dynamic columns / Structure to MS access from SQL Server. I tried this with DTS , but it did not work.
    Rohit Chitre

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    what do you mean by dynamic columns?

    You could do something like This

    But it only gets the data out

    What method does DTS use to get the data in to Access I wonder.

    COM Objects?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2004
    Posts
    15

    SQL Export

    Thanx for ur reply.
    Actually, end users are using a Query tool.Through this tool they can extract any No. of columns. After extracting this data they need this data to be exported to MS - Access so that they can Quality Check it and send it to the client.

    The columns that users will extract are always varying.They are querying on
    SQL 2000 database. and output is shown in a grid. Currently data is being exporeted to Excel file using Grid's default properties. But if data exceeds 15000 mark this defualt method takes chunk of time which is not affordable.

    The requirement for this tool is , after creating the table in SQL Server it should be exported to MS - Access.


    The BCP command gives some problems with SQL Server 2000 i.e. few rows may not get exported to the text / data file.
    Rohit Chitre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •