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 |
|
bogus
Starting Member
41 Posts |
 Posted - 2008-12-22 : 13:44:27
|
This is really beginning to make me very angry...I am trying to import an excel spreadsheet, Excel 2003, into a SQL Server 2000 database. The table is being created and I am using the import wizard.I have also tried this with an existing table.The problem: I have a part number from our catalog. Some are numeric (99999) and others are alpha (100-200-ABC). The 2nd type are not being imported, even though the column is defined as text and the table is defined as varchar.I am so frustrated with something that should only take 5 minutes... argh. |
|
|
bogus
Starting Member
41 Posts |
Posted - 2008-12-22 : 14:24:09
|
| I got the garbage in... I had to save as CSV then import. $#@!$#@ bastage. |
 |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-01-02 : 09:15:46
|
| the import should create the destination columns.....Kind RegardsPete. |
|
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-01-02 : 09:19:23
|
| Bogus,Change the excel file to csv and import using BCP there is a good description of how to use it in Books OnlineKind RegardsPete. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-02 : 09:21:12
|
| or you can even try with OPENROWSET |
|
|
|
bogus
Starting Member
41 Posts |
Posted - 2009-01-06 : 20:28:21
|
| I will investigate BCP!Thanks! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
ramvprasath
Starting Member
1 Post |
Posted - 2009-03-02 : 07:51:32
|
| HI Everyone, I Want to import an excel spreadsheet to sql server database. I want the excel sheet to be imported to the database from VB in a click of a button.Pls guide meThanksRam |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-02 : 08:01:55
|
quote:
Originally posted by ramvprasath
HI Everyone, I Want to import an excel spreadsheet to sql server database. I want the excel sheet to be imported to the database from VB in a click of a button.Pls guide meThanksRam
See this linkhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Importing data from Excel