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 |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2012-03-29 : 17:38:40
|
| Is it possible to import from an excel file into a SQL Server database table? How? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2012-03-29 : 19:03:37
|
| And I prefer to give a requirement that I ONLY Accept a delimited or fixed width raw data file..no excel, no access, no word, no 1-2-3, no abacus, no dbaseIII, no anything that is in a proprietary formatDig?The bcp that data to an emptu staging table where all the columns are varchar(max)The perform audits, integrity and whatever other checks you wantIf it fails, tell the sending bonehead to fix the fileIf not, populate your relational tableIt is WAY past 5:00Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/ |
 |
|
|
|
|
|
Importing data to empty table