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 |
|
ingineu
Yak Posting Veteran
89 Posts |
 Posted - 2006-03-06 : 15:00:46
|
I am attempting to export a SQL table to a new excel sheet. My Excel VBA code follows:strSQL = "SELECT * INTO [Excel 8.0;Database=C:\Test.xls].[TestSheet] FROM dbo.tblTest"conn.Execute strSQL, , adCmdText I receive the following error message:Specified owner name 'Excel 8.0;Database=C.\Test.xls' either does not exist or you do not have permission to use it.I'm running Excel 2002, does that make a difference, or is it referring to SQL permissions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-06 : 15:20:03
|
| Your code is attempting to create a SQL Server table called TestSheet with an owner of "Excel 8.0;Database=C:\Test.xls". You are getting the error because that owner does not exist.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Export SQL table to new Excel sheet