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 |
|
Sunaina Koul
Starting Member
7 Posts |
 Posted - 2007-09-21 : 01:50:15
|
| Need help...I am working on Ms Access and want to Export all data of a table into excel sheet through vb script or sql query?waiting for replyRegards,Sunaina Koul |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-21 : 02:12:59
|
| http://www.exceltip.com/st/Import_data_from_Access_to_Excel__(ADO)_using_VBA_in_Microsoft_Excel/427.htmlMadhivananFailing to plan is Planning to fail |
 |
|
|
Sunaina Koul
Starting Member
7 Posts |
Posted - 2007-09-21 : 02:43:41
|
| Thanks.Got it using ADO.Is it possible do the same thing through Sql?I am so good at Sql.Regards,Sunaina Koul |
|
|
|
Sunaina Koul
Starting Member
7 Posts |
Posted - 2007-09-21 : 03:11:34
|
| oh...SOrry .I mean i am not so good in SqlRegards,Sunaina Koul |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Sunaina Koul
Starting Member
7 Posts |
Posted - 2007-09-21 : 05:29:32
|
| Thanks a lot,once again...Regards,Sunaina Koul |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-21 : 06:57:45
|
quote:
Originally posted by Sunaina Koul
Thanks a lot,once again...Regards,Sunaina Koul
Welcome. Note that you should try the code in SQL Server and not in ACCESSMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Export into Excel