Web Development

Ask something
Discussion Locked

Access and SQL Server 6.5

0 helpful
6 replies

by pjsinclair

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is it Possable to extract data from a SQL server (then get rid of your SQL server) and use the data in Access. If this is possable could you inform me of how to do it.

regards
PJS

6 replies

by sgt_shultz

have you attached the database to access to have a look yet? how many tables? how many queries? how many users?

by pancras

You can attach access to sqlserver.

File-Get external data- link. then use odbc type to connect to sqlserver.
Link to all the tables.
Then use maketable queries on all the linked tables to create native access tables.
OR
Simply use File-Get external data-import

by techsupportspecialist

Yes, it is possible.

First of all, you need to have an ODBC connection set up. If you already have one, then you can skip to step 11:

1) Open Control Panel
2) Administrative Tools -> ODBC Data Sources
3) File DSN Tab
4) Add
5) SQL Server
6) Browse and create a DSN file anywhere
7) Finish
8) Create a description
9) Select the SQL Server from the dropdown
10) You will have to complete the rest of the wizard entering the correct information for your server
11) Open the Access database that you want to create the tables in
12) Right-click in the database window
13) Import
14) Select ODBC for Files of Type
15) Browse for the dsn file you created
16) From here, the rest should be self-explanatory

I hope this helps. Good luck.

This discussion is closed to new replies.