Exporting tables from SQL 2008 DB

[Steve Savo]

I previously used Enterprise Manager to export various tables from a hosted
SQL DB to a local Access DB to enable me to run various custom reports.

This was all fine until FastHosts decided to upgrade to SQL 2008 without
warning.

What is the best way to export these tables from the new SQL 2008 db?

Cheers
Steve

 

[Sylvain Lafontaine]

No, Enterprise Manager cannot be used to connect to SQL-2000 but the Query
Analyser should still be capable of connecting. For SQL-2000, the
replacement of both EM and QA is the SQL-Server Management Studio (SSMS).
The Express version of SSMS 2008 (SSMS-E) is available free of charge but I
don't know if it can make a remote connection:

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

The developer edition is available for around 50$:

http://www.google.com/products/cata..._catalog_result&ct=result&resnum=1#ps-sellers

(Note: the 2008 Developer is hard to find on many sites like Amazon because
they call it SQL Svr 2008 instead of SQL Server 2008; see:

http://www.amazon.com/gp/product/B001B8EZR4

In all cases, you don't need any of these programs to import your data as
any version of Access should be able to directly import the data via ODBC
(with or without using linked tables) and/or OLEDB if you have a direct
access to the remote SQL-Server from your local machine.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Steve Savo]

Sylvain,

Thanks for your response - I have created a bunch of linked tables via an
ODBC datasource and it works a treat!

Cheers
Steve

 

[Steve Savo]

Sylvain,

Thanks for your response - I have created a bunch of linked tables via an
ODBC datasource and it works a treat!

Cheers
Steve