Export Tables to SQL Server

[Phil]

I have a database already in Access 2003, and want to export the structure
(just the tables, not the data) into SQL Server Express 2005 (there are no
stored queries, macros, etc... to worry about).
What's the easiest way to do this?
I've tried using the Upsizing Wizard, but it doesn't seem to want to talk to
SQL Server Express.

Thanks
Phil.

[Tom Wickerath MDB]

you shoudl get a copy of SLQ Server Developers Edition and learn how to use
DTS

or if you go file, new, project (existing data) you should be able to import
SOME tables into SQL Server just using MS Access

"Phil" <N/A> wrote in message
news:4652de28$0$8733$ed26...@ptn-nntp-reader02.plus.net...

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Tom Wickerath MDB" <tom_wi...@hotmail.com> wrote in message
news:e8N9PnZn...@TK2MSFTNGP03.phx.gbl...

[Tom Wickerath MDB]

hey gunny

lick my ass pussy mdb script kid

"'69 Camaro" <ForwardZERO_SP...@Spameater.orgZERO_SPAM> wrote in
message news:O2hdjuZn...@TK2MSFTNGP05.phx.gbl...

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Tom Wickerath MDB" <tom_wi...@hotmail.com> wrote in message

news:%236de4Sb...@TK2MSFTNGP06.phx.gbl...
> hey gunny
>
<SNIPPED>

[Phil]

> you shoudl get a copy of SLQ Server Developers Edition and learn how to
> use
> DTS

I have seen references to using DTS for this, but I think in 2005 DTS has
now been replaced with something called SSIS is that correct? Unfortunately
this does not appear to be included in SQL Express.
I would prefer to do this without purchasing the developer edition if at all
possible.

>
> or if you go file, new, project (existing data) you should be able to
> import SOME tables into SQL Server just using MS Access
>

OK. I tried this, and created an Access Project, but when I enter the
details to connect to SQL Server, I get a similar error to when I tried to
use the upsizing wizard - SQL Server does not exist or access denied.

Cheers,
Phil.

['69 Camaro]

Sorry. You've been attacked by the resident troll masquerading as someone
else. He has no intention of helping you. Please start a new thread,
because this one is trashed. Sorry for the inconvenience.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Phil" <N/A> wrote in message

news:46558b10$0$8758$ed26...@ptn-nntp-reader02.plus.net...

[Phil]

> Sorry. You've been attacked by the resident troll masquerading as someone
> else.

Maybe.

> He has no intention of helping you.

Well the information he has provided appears to be accurate and relevant to
my question, even if my problem has not been solved yet. No-one else has yet
responded with anything more useful. I'm not interested in your personal
squabbles, but if you can shed any light on my particular issue, I'd be very
grateful for your input.

Thanks,
Phil.

[Tom Wickerath]

developer edition is $49

I mean get real, kid

"Phil" <N/A> wrote in message

news:46558b10$0$8758$ed26...@ptn-nntp-reader02.plus.net...

[Tom Wickerath]

thanks phil

"Phil" <N/A> wrote in message

news:4655905f$0$8715$ed26...@ptn-nntp-reader02.plus.net...

[Tom Wickerath]

SQL 2000 DTS is great.. SQL 2005 is called SSIS

I don't know SSIS that well because DTS 100% meets my needs for everything I
do.

I'd honestly reccomend 2000; I think that it's a lot easier to use

I mean the import expot data wizard?
In 2000 it 'just works'

in 2005; it's a pain in the butt and it's slowr

"Phil" <N/A> wrote in message

news:46558b10$0$8758$ed26...@ptn-nntp-reader02.plus.net...

[Tom Wickerath]

SQL Server does not exist or Access Denied?

are you using a machine name or a IP address?
SQL Authentication or Windows Authentication?

Does the SQL 2005 Express instance have remote connections enabled

"Phil" <N/A> wrote in message

news:46558b10$0$8758$ed26...@ptn-nntp-reader02.plus.net...

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Tom Wickerath" <tom_wi...@hotmail.com> wrote in message
news:OHpxqWin...@TK2MSFTNGP03.phx.gbl...

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Tom Wickerath" <tom_wi...@hotmail.com> wrote in message

news:%23sU70Wi...@TK2MSFTNGP03.phx.gbl...
> thanks phil

['69 Camaro]

HTH.
Gunny

news:%23V$O0XinH...@TK2MSFTNGP02.phx.gbl...

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Tom Wickerath" <tom_wi...@hotmail.com> wrote in message

news:OCVhXYi...@TK2MSFTNGP06.phx.gbl...

['69 Camaro]

Aaron absolutely hates Microsoft because they fired him. He jumps into
threads in the newsgroups and may appear to help at first, but he
intentionally misleads the person most of the time. His intention is to
disrupt and to drive Microsoft's customers away. He's been doing this
nearly every weekday for several years. He never grows tired of it.

If you blindly follow his advice, you may run into big trouble. Aaron may
also give the correct advice about 5% of the time. Caveat emptor.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Phil" <N/A> wrote in message

news:4655905f$0$8715$ed26...@ptn-nntp-reader02.plus.net...

[Phil]

> SQL Server does not exist or Access Denied?
>
> are you using a machine name or a IP address?

I just selected the machine name from the list

> SQL Authentication or Windows Authentication?

I tried both, but neither seemed to work.

>
> Does the SQL 2005 Express instance have remote connections enabled

Not sure, I'll check that, but I'm not using a separate server machine,
everything is installed on my own machine under XP.

[Phil]

> developer edition is $49

I expect it will be a little more expensive here in the UK but I haven't
really looked into prices. At this stage I am just evaluating the free SQL
Express version, and wanted to import a familiar database to check a few
things out.

[Chris Mills]

That amounts to about 8 similar posts in this one thread, Gunny, and there
seem to be hundreds of exactly equal other posts from you ("Gunny") in
multiple ng's. I am suggesting this amounts to an unreasonable "fetish", EVEN
IF the poster is an imposter of your friend.

I suggest, Stop It. Answer the technical question, which you may be better at.

Chris

"'69 Camaro" <ForwardZERO_SP...@Spameater.orgZERO_SPAM> wrote in

message news:OQhzRri...@TK2MSFTNGP06.phx.gbl...

['69 Camaro]

Hi, Chris.

> there
> seem to be hundreds of exactly equal other posts from you

Correct. Aaron posts about 300 to 600 messages per month, so expect many,
many thousands more.

> I suggest, Stop It.

Now why didn't the rest of us think of that? Aaron, stop it.

There. It's all fixed now. Chris, I'll send you the bill for my services.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Chris Mills" <phad_...@cleardotnet.nz> wrote in message
news:uQplfL0q...@TK2MSFTNGP03.phx.gbl...