Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 28th, 2006, 03:54 PM
Registered User
 
Join Date: Feb 2006
Location: Media, PA, .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Read SQL Server 2000 files into MS-Access

Is there any way to read a SQL Server 2000 file into MS-Access without having SQl Server installed on the same machine? All methodfs we have looked at seem to require SQL server to be installed.

 
Old February 28th, 2006, 04:26 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You should be able to use the MSDE (Microsoft Data Engine) for that purpose. It is available as a FREE download from Microsoft.

MSDE is a version of SQL Server with limited functionality.

Rand
 
Old February 28th, 2006, 04:28 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here is the URL:

http://www.microsoft.com/downloads/d...displaylang=en



Rand
 
Old February 28th, 2006, 05:07 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Define "read a SQL Server 2000 file into". Do you mean attach a SQL table or import the data from a SQL table into an Access table? Depending on the answer, the solution is different.

Since you already have SQL Server, you just need the SQL ODBC drivers. You can install those without install all of SQL Server, and then you can import or the SQL data into Access.

 
Old February 28th, 2006, 05:33 PM
Registered User
 
Join Date: Feb 2006
Location: Media, PA, .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

We would ideally really like to able to read SQL Server 2000 (or, 2005) dbms files from MS-Access (2003) without, necessarily, having to have any element of SQL Server being present on the same machine (or, in short, more so, the user necesarily having to install, or, learn the ins and outs of SQL Server!). We would, if possible, like to do this in MS-Access 2003. We probably do not understand adequately as well as should why this transformation should be too tough. We have not yet found a reference or a script out there that talks us meaningfully through it. We would like to find an article that adequately lays out the optiosn for linking/transformations, etc. Does anyone know of such a script(s)? One would think this this might be activity that a sizeable section of folks might want to do, that is, simply read SQL Server files from MS-Access (2003) off-line! We have got rather stuck here so we really appreciate any further specific input, guidance or reference.

 
Old February 28th, 2006, 10:00 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Well, unfortunately I am pretty sure what your asking is not possible. In order to read/access SQL Server you need the SQL Server odbc drivers so that Access can get to SQL, and I think the only way to get those is to install the SQL client. UNLESS they are installed with version 2.0 of teh .NET Framework. I don't think they are but I will check (because I could be wrong and I will happily admit it if I am). :-)

 
Old March 1st, 2006, 10:59 AM
Registered User
 
Join Date: Feb 2006
Location: Media, PA, .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It would be highly interesting and useful to know if you can install drivers so that Access can directly load SQL server files. As a neophyte I would have thought these might have been supplied with Access (2003), but may be we are missing something in the big schema here? Really appreciate any further feedback you can supply!

 
Old March 1st, 2006, 12:25 PM
Friend of Wrox
Points: 2,101, Level: 18
Points: 2,101, Level: 18 Points: 2,101, Level: 18 Points: 2,101, Level: 18
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: , , .
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

I think Scott has it right. Generally Word is used to read Word files and Excel is used to read Excel files. SQL server is used to read SQL database files and so on. You can import/export from database to database but as far as using one application to read files from another application I don't think that's going to work so well.

 
Old March 1st, 2006, 04:21 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Just push the data from SQL using DTS Export and dump them into an Access database. I make back ups for Access OLAP using this method.

Alternatively, you can push to Excel, or Pull (import) from Access.

All of these methods require the SQL Server to be running. If you don't have SQL Server, you can probably borrow a trial for this process.

HTH


mmcdonal




Similar Threads
Thread Thread Starter Forum Replies Last Post
How Run .sql Script file in MS SQL Server 2000? aarkaycee SQL Server 2000 5 October 12th, 2009 05:43 AM
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS Access .mdb calling SQL server 2000 stored proc fazzou Access 6 September 8th, 2006 11:32 AM
Import Data In MS SQL SERVER 2000 The Beginner Classic ASP Basics 1 August 14th, 2006 04:59 PM
Save Pictures in MS SQL Server 2000 kudzuconf SQL Server 2000 1 March 15th, 2006 11:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.