General discussion

Locked

Access and SQL Server 6.5

By pjsinclair ·
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

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to Access and SQL Server 6.5

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

Collapse -

by pancras In reply to Access and SQL Server 6.5

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

Collapse -

by pjsinclair In reply to

Poster rated this answer.

Collapse -

by TechSupportSpecialist In reply to Access and SQL Server 6.5

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

Collapse -

by pjsinclair In reply to

Poster rated this answer.

Collapse -

by pjsinclair In reply to Access and SQL Server 6.5

This question was closed by the author

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums