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 |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2006-08-04 : 00:35:28
|
| I am executing the following statement.It works fine.select * into [AllAntigen] from opendatasource ('microsoft.jet.oledb.4.0','data source= "G:\SSAFolder\MissDocs\SSA pricing extract\SSA pricing extract.xls";extended properties=excel 5.0')...[AllAntigen$]If I have spce in the Sheet name,it does not work.( Space in [All Antigen$]).I have googled and could not find any help.Any Help would be really appreciated.Thanks!Raju |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2006-08-04 : 01:08:48
|
| try using quotes 'All Antigen$' or "All Anitigen$", hopefully one of those will do the trick. |
 |
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-08-04 : 01:32:08
|
Enclosing in the single quote did the Trick.Thanks! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Loading Excel File into the Tables