Export Tables to SQL Server

P

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.
 
T

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
 
T

Tom Wickerath MDB

hey gunny

lick my ass pussy mdb script kid



'69 Camaro said:
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.
Click to expand...
 
P

Phil

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

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
Click to expand...
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.
 
6

'69 Camaro

P

Phil

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

He has no intention of helping you.
Click to expand...

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.
 
6

'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.
 
T

Tom Wickerath

thanks phil


Phil said:
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.
Click to expand...
 
T

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
 
T

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
 
P

Phil

SQL Server does not exist or Access Denied?
are you using a machine name or a IP address?
Click to expand...

I just selected the machine name from the list
SQL Authentication or Windows Authentication?
Click to expand...

I tried both, but neither seemed to work.
Does the SQL 2005 Express instance have remote connections enabled
Click to expand...

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

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.
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Dumb question alert! What program to use? 0
linking to SQL Server db table 6
VBA to export large tables from Excel to SQL Server 1
ODBC Error en Organigrama en Visio. 0
URGENT: Exporting table to an SQL script 13
Keeping Access Running Between SQL Server Reboots 3
Trouble upsizing Access to SQL 5

Top