Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: exporting SQL data as Access readable file

    hi guys.

    i'm looking to try and get a web tool together that will basically allow a user to download a file that can be plopped into MS Access, using the data i have on my servers stored in MS SQL Server...

    any ideas?

  2. #2
    Join Date
    Dec 2003
    Posts
    2
    nobody, huh?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    bcp out a data file?

    You need to be clearer on your process and what you're trying to do..

    I'd venture to say that a stored procedure will be called, then using xp_cmdshell bcp out a view or use queryout...

    But a little more explination would help us...
    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.

Posting Permissions

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