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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-27 : 08:49:42
|
| Katarina writes "What ASP component do you recommend for uploading .csv or .xls files from a Web browser into database (table) on SQL Server? Also for downloading a table from SQL Server into a .csv or .xls file from a Web browser." |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2001-11-27 : 10:08:05
|
| You can try either SA-FileUp or ASPUpload:[url]www.softartisans.com[/url][url]www.aspupload.com[/url]Both of these components can upload the .csv or .xls file as a BLOB into the database. However, they won't import the columns of data in these files into the corresponding table columns in your database. To do that, I suggest using BCP on the .csv file or converting the .xls file to a tab-delimited file. |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2001-11-27 : 11:07:13
|
| BCP can't read CSV files with quote-escaped fields. Bizarrely, DTS can. |
|
|
|
|
|
|
component for uploading .csv or .xls files into database