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 |
|
psreee
Starting Member
2 Posts |
 Posted - 2014-08-11 : 13:38:01
|
| Can you help to create table for excel sheet data.excel sheet data.column hereCIBMTR Center Number Center Name State CRID Event Date Event Year HRSA Translated Donor Type Product Description Primary Ethnicity Gender HRSA Race Birth Date Patient Age Age Group Broad Disease Code Broad Disease Name Specific Disease Code Specific Disease Name HRSA Broad Disease Name HRSA Specific Disease Name Disease Status Translation Cellular Therapy Type RF_OR_TED Consent Flag FormsNet Infusion ID Malignant Flagsample data:11048 Children's Hospital Of Pittsburgh PA 6280 04/03/2013 2013 Autologous Peripheral Blood NA - Not Applicable F Black or African American 09/14/2001 11 11--20 AI Autoimmune diseases CROHN Crohn's disease Autoimmune Disease Crohns disease Not Applicable HSCT TED Y 466040 N |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-11 : 13:57:03
|
| You can use the import wizard to create the table for you. It'll read the file and determine the table layout. You can make some changes to it if any of the column definitions are off.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
How to create table from excel sheet data