Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Export table to excel ?
Hi, I´ve read some about it, the BCP function. Problem is i´m pretty new at this stuff. Problem is how to sort out the csv file ex. import.csv article1, 50 article2, 30 article3, 35 etc .. How do I loop this item´s into the database tables ? Articles to tbl_article and price´s to...- 6291941
- Post #5
- Forum: Sybase: Adaptive (SQL) Server
-
Export table to excel ?
Thx PDreyer, I´m gonna try i right away! By the way .. If you have an excel ark with columns. Let´s say A1, B1. A1 is listing article and B1 is listing price. This is a long list. products.xls A1 B1 Article 1 50 Article 2 40 Article 3 30 etc .. etc.. In Adaptive SQL...- 6291941
- Post #3
- Forum: Sybase: Adaptive (SQL) Server
-
Export table to excel ?
Hi, Have a little question regarding exporting data from a database table to an Excel ark. Is there any SQL statement you can use to do that ? Export att whole table with it´s columns and data. The columns in the excel ark (A1, B1, C1, D1 etc) are gonna be replaced with the columns in the...- 6291941
- Thread
- Replies: 4
- Forum: Sybase: Adaptive (SQL) Server
-
Export database table into a Excel ark ?
Hi, Have a little question regarding moving data from a database table to an Excel ark. Is there any SQL statement you can use to do that ? Export att whole table with it´s columns and data. The columns in the excel ark (A1, B1, C1, D1 etc) are gonna be replaced with the columns in the...- 6291941
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
