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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-01-13 : 05:38:06
|
| Hi,I would like to read a data inside a .xls file.The column headers are in row 4 and below them are the data for each columns.The name of the sheet is global.In excel source, I am using sql command with the following sql:select * from [global$A4:AB5000]error is: external table is not in correct formatThanks |
|
|
|
|
|
excel range