OK, how do I convert a SQL Server database file to an Access database file ?

Randy

You want to go the other way to most people
<grin>(http://support.microsoft.com/default...;en-us;Q237980)

OK So there is no "Down sizing" tool i know.

How much of the SQL Server functionality do you want to take with you?

The two products are different animals and a one-one mapping of features is
not there.

DTS can be used to transfer the data and table structures ure but will no
move relationships, constraints, stored procs etc etc.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"rseedle" <rseedle (AT) discussions (DOT) microsoft.com> wrote

I just need to convert the data and database structure. I don't use Access
normally but I need it to support a website I am building. The hosting
company only supports Access. I guess I can't grip its real cheap.

Randy

"rseedle" wrote:

Then DTS will transfer the structure and data for you. You will need to
perform any necessary triage after that yourself though.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"rseedle" <rseedle (AT) discussions (DOT) microsoft.com> wrote

Allan:
Neither www.SQLDTS.com or www.SQLIS.com displays anything. I get a blank
screen. The www.konesans.com is a consultant. I need to do this myself. No
money to pay others to do the job. Have you got any other solutions ? Is
there a utility for Access like BCP in SQL Server ? I don't have a copy of
Access though so that could be a problem. Is there a Northwind database for
Access ? Two of the database tables are from the Northwind database.

Randy


"Allan Mitchell" wrote:

We are having problems with the www.SQLDTS.com and www.SQLIS.com websites.
www.Konesans.com is our consulting arm and I never you suggested you contact
us and pay us to provide a solution. We are always more than happy to
provide help on this forum as much as we can.

You want to take data and table structure from SQL Server to Access?

Do the tables in Access already exist? If they do and you can see the
database then in a transform data task you can simply select the Source
table from which you want to move data and then in the destination tab you
can select the access connection. On the transformations tab you will then
be able to map the columns.

You can also have DTS create the destination tables for you.

You can use the Import/Export wizard to achieve this also.

Not having a copy of Access will be a problem in so much as you will not be
able to open the Access DB after you have filled it with data. It will not
stop you loading it with data though.


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"rseedle" <rseedle (AT) discussions (DOT) microsoft.com> wrote