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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-04-07 : 15:43:40
|
| Hi, I have an excel spreadsheet with some 7 cols of data and table in database with the same 7 cols. Is there a way similar to Excel and ACCESS db that I can import the data into table without writing a program which will open a file, read each column by parsing and inserting into table?Thanks,Sarat |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-07 : 16:17:21
|
| DTS can import the data from Excel into a SQL Server table or an Access table. Is that what you are looking for? You can either create a DTS package from scratch or by using the DTS wizard.Tara |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-04-07 : 17:07:30
|
| Ya, I looked at DTS but I have a problem using DTS on production box which I am hoping to fix when I apply service pack 3.Apart from that I was looking for a way to do in Query Analyzer (some existing stored procedure which can be modified or which requires parameters that can be supplied).Also, not all of us have EM or authority to execute DTS tasks so I was thinking if there is a script which developers can use to rerun. This import is going to be in tens of hundreds of batches and running scripts/procedures may be easier.thanks,sarat. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-07 : 17:13:51
|
| Well I would not suggest installing service pack 3 on your production box if you are planning to use DTS. Service pack 3 crashes Enterprise Manager when you are doing a particular task in DTS. I forget the particular task but I believe it had to do with importing data from a text file or exporting data to a text file. This is exactly why my company is not installing service pack 3 on any of our servers at this time. We have no need for service pack 3 since we have not encountered any of the bugs that it fixes. We are fine on service pack 2 with the cumulative security patches installed. If you do not want to use DTS, you can use VB to code against the DTS APIs, but I don't have ANY experience on this and I doubt that many people do either, so you might be on your own this. I kinda figured that you already knew about DTS considering the complex questions that you asked here, so that's why I wasn't sure if that was what you were looking for. DTS is defintiely what you want to use here, well IMHO. You do not have to create the DTS packages on the production box. You can create it anywhere (well anywhere that has Client tools installed and can get to the appropriate servers), then copy it over by doing a Save As...Tara |
|
|
|
|
|
|
|
|
Importing data from excel into SQL Server table