Post reply

Creating Access DB from SQL Server Express

  • December 7, 2007 at 4:53 pm

    #181954

    Hi all -

    I have a db that I am manipulating in SQL Server Express. The idea is to create a subset of that database that our client can manipulate easily (there is a longer story but....).

    I want to create an Access DB from the subset database that I have created with all keys and relationships intact. Is there an easy way to export everything, or alternately, import it all from Access?

    I figured out how to link on the data through the OBDC, but that isn't exactly what I want since the client may not have SQL Server to connect to all the time.

    Any suggestions?

    Thanks in advance,

    SA

  • December 10, 2007 at 11:53 am

    #758710

    Hi -

    Responding to my own post, I saw there were visits but no responses. If anyone else is looking....

    Found it was easy enough to, instead of "linking" to the database, I could "import" the data of ODBC file types. Using the same process to create a new DSN as shown here:http://www.sqlservercentral.com/articles/Access/linkingaccesstosqlserver/2176/

    Importing brings in data, column headings, and data types nicely, but you have to set up your own PKs and FKs, much like INSERT INTO would do. Not a problem if, like me, the database is fairly limited.

    Best,

    SA

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

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