Joshua
Reputation:
Importing excel spreadsheet in sql server 2000
I have a question regarding importing( Via the import/export wizard) an excel spreadsheet into sql server 2000.
Everything seems to run fine, no errors etc, but when I select the data from my table, I've noticed that it skiped the first row. I thought maybe there was a "1st row is Data headers" flag , but I can't seem to find anything like that. Any help would be appreciated.
Upvotes: 1
Views: 735
Answers (1)
Joshua
Reputation:
I was using Enterprise Manager with no Luck. I tried Microsfot SQl Server Management Studio and it worked fine. Studio had an option (first row is column headers) that Enterprise manager didn't.
Upvotes: 1
Related Questions
- How to import data from Excel 2007 xlsx file into SQL Server 2000 Database?
- SQL Import from Excel Spreadsheet
- How do I import an excel spreadsheet into SQL Server?
- Importing data from Excel to SQL Server
- importing data from excel to SQL server 2008
- Sql Import from excel
- Import excel file in sql server 2008
- SQL Server 2008 import excel file
- sql server 2008: importing data from excel 2003 file
- SQL Server 2005 Import from Excel