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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-10 : 09:11:52
|
| Jet writes "I am using sp_addlinkedserver, in a stored procedure, to create a linked server to an excel spreadsheet uploaded to the web server. One column on the spreadsheet is formatted as general and may contain either numeric or alphanumeric data. When the linked server is created and the data is moved to the database some of the cells are blank. I have also noticed this problem when I import the spreadsheet directly into sql server using a DTS. Having the user change the cell format is not an option." |
|
|
|
|
|
Missing cell data on excel imports