Re: file conversion from SQL Server to Access
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 8 Aug 2005 21:31:11 +0100
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A89F3BB4-2E96-4A94-B329-0B5886221565@xxxxxxxxxxxxxxxx
> 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:
>
>> You want to go the other way to most people
>> <grin>(http://support.microsoft.com/default.aspx?scid=kb;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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:021088D1-058C-4CAA-B579-54BDC8C6F8BB@xxxxxxxxxxxxxxxx
>> > OK, how do I convert a SQL Server database file to an Access database
>> > file
>> > ?
>> >
>> > Randy
>>
>>
>>
.
- References:
- file conversion from SQL Server to Access
- From: rseedle
- Re: file conversion from SQL Server to Access
- From: Allan Mitchell
- Re: file conversion from SQL Server to Access
- From: rseedle
- file conversion from SQL Server to Access
- Prev by Date: Re: file conversion from SQL Server to Access
- Next by Date: Scheduled job to run a DTS package under SA
- Previous by thread: Re: file conversion from SQL Server to Access
- Next by thread: RE: file conversion from SQL Server to Access
- Index(es):
Relevant Pages
|
