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 |
|
kpeck
Starting Member
13 Posts |
 Posted - 2005-04-26 : 11:33:40
|
| I have over two hundred csv files that I need to import. I would like to import them all at once into their own tables.Any help would be appreciated |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
speterson
Starting Member
11 Posts |
Posted - 2006-01-04 : 09:54:44
|
| So the links here will allow me to automatically import my 800+ text files into 800+ different SQL database tables as opposed to me manually importing them one at a time via the Import wizard?I just want to verify that I am understanding this correctly. I appreciate the help! |
 |
|
|
vijayalakshmi
Starting Member
1 Post |
Posted - 2006-01-10 : 05:24:58
|
| I want to export the matrix report format to excel.during that some fields are repeated and some fields are truncated.please give me solution how to get excel report from matrix report in report 6i |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-10 : 05:31:23
|
| >>please give me solution how to get excel report from matrix report in report 6iAre you referring SQL Server Reporting Service?If you want to export from Table,see if this helpshttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-01-10 : 07:15:50
|
quote:
Originally posted by speterson
So the links here will allow me to automatically import my 800+ text files into 800+ different SQL database tables as opposed to me manually importing them one at a time via the Import wizard?I just want to verify that I am understanding this correctly. I appreciate the help!
The links give a method of importing all files that arrive in a directory. It imports them all into the same table but it's a small change to import each one into a different table - you just have to add the code to select the table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Import multiple files