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 |
|
andrewz00
Starting Member
15 Posts |
 Posted - 2009-06-11 : 13:56:20
|
| i have referenced [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[/url]...and i have tried the followingselect * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=//wbfs/userdate/azahn/text.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')but still cant get it to work. thoughts? |
|
|
shackclan
Starting Member
8 Posts |
Posted - 2009-06-11 : 14:27:49
|
| is the error you are receiving related to either data type or data size issues?Thanks,shackclan |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-12 : 01:52:14
|
quote:
Originally posted by andrewz00
i have referenced [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[/url]...and i have tried the followingselect * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=//wbfs/userdate/azahn/text.xls;HDR=YES', 'SELECT * FROM [Sheet1$]')but still cant get it to work. thoughts?
You need to give more info on what is not workingMake sure you have spelled the file path correctlyMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Import Excel