Export data from Sql Server 2005 to MS Access

  • I've been given the task of transferring data from a Sql Server 2005 database to an Access database. I know I can use the wizard to accomplish this, but here's the problem - I only want to copy data for certain organizations. Something to this effect:

    Select *

    From Every table

    Where OrganizationID between x and y

    I'm guessing a SSIS package is the best way to accomplish this, but I have no idea where to start. ANY suggestions would be greatly appreciated.

  • the Export Wizard gives you the option of copying tables or using a query in like the sixth step: much easier using the wizard than SSIS.

    you have to select your existing server as the source, then choose Access for the destination.

    you have to point to an existing .mdb access database file...it doesn't create one on the fly.

    the next step is this, asking whether to use a table or a query:

    the next screen lets you paste your query and then finalize it. you might have to repeat it for each table name;

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks.

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

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