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.

 All Forums
 Other Forums
 SQL Server 6.5 \ SQL Server 7.0
 How to export table in SQL6.5 to excel file?

Author  Topic 

pberp
Starting Member

15 Posts

Posted - 2009-12-28 : 22:54:47
Just export the data of table.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-29 : 10:57:47
You can use bcp.exe and specify comma as your column delimiter.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

pberp
Starting Member

15 Posts

Posted - 2009-12-31 : 00:31:13
quote:
Originally posted by tkizer

You can use bcp.exe and specify comma as your column delimiter.



Do you mean that I can output only text file by bcp.exe?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-31 : 02:22:02
That's how you do it in 6.5. Upgrade to a newer version to get more features such as DTS/SSIS.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Trevinator
Starting Member

8 Posts

Posted - 2012-11-02 : 19:27:53
quote:
Originally posted by pberp

Just export the data of table.

Go to Top of Page

Trevinator
Starting Member

8 Posts

Posted - 2012-11-02 : 19:28:41
Are you trying to get the file out of the command line or are you using a export/import wizard?
Go to Top of Page
   

- Advertisement -