Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgraves
Starting Member
29 Posts |
 Posted - 2009-04-09 : 11:18:41
|
| I have a table which contains some data I would like to export to Access. Is there a way to select and export just that data without exporting everything in that table?Thanks for any help.Scott |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-04-09 : 14:00:59
|
| yes. If you are using DTS, you can specify a query to transfer data. Alternatively, You can define a view with filters you want and export using that view. |
 |
|
|
sgraves
Starting Member
29 Posts |
Posted - 2009-04-09 : 15:16:21
|
| Can you give an example of how I should do this? I am fairly new to this and I am not sure how to start.Thanks!Scott |
|
|
|
pmohans123
Starting Member
5 Posts |
Posted - 2009-04-10 : 07:11:08
|
| Hi Scott,Go to the corresponding DB and right click, then select the 'Task -> Export Data' now u will get the Import and Export wizard, Give Source (current instance name), destination access DB, after that you have to select 'write a query to ....' option. there you can give the query to get the expected result set.I hope this will help you. Let me know if you have any issuesThanksMohan |
|
|
|
|
|
|
exporting data