|
-
November 17th, 2008, 06:26 AM
#1
 conversion from one database to another
I have a table in SQL i want to convert it to ACCESS
-
November 17th, 2008, 08:11 AM
#2
Re: conversion from one database to another
 Originally Posted by kriti
I have a table in SQL i want to convert it to ACCESS
1) Open Access
2) Attach to SQL Table
3) Run an Insert Query.
OR
1) Open Access
2) Select Import
OR
1) Open Management Studio
2) Export Table to Flat File
3) Open Access
4) Import Flat File
TheCPUWizard is a registered trademark, all rights reserved. (If this post was helpful, please RATE it!)
 2008, 2009,2010
In theory, there is no difference between theory and practice; in practice there is.
* Join the fight, refuse to respond to posts that contain code outside of [code] ... [/code] tags. See here for instructions 
* How NOT to post a question here 
* Of course you read this carefully before you posted 
* Need homework help? Read this first 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
