September 12, 2002 at 7:55 am
I have two books on SQL Server (Black Book and Unleashed) and have been working thru the DTS sections in each as I try to figure out how to pull a table from a SQL Server 2000 database into an MS Excel 2000 spreadsheet. I have also looked thru this site and thru SQLDTS.com ... and I can't find any gotchas for an SQL to Excel DTS operation. However I still can't seem to make it work.
I can, via the Import/Export Wizard, pull this table over into MS Access, but I have tried a million different things and I still can't do this into Excel. Am I missing something? Can anyone add anything? I'm pulling my hair out because I know it's probably somehting simple. Here's what I'm doing ...
Open wizard -> choose and configure source -> choose destination (tried ALL Excel drivers) -> "Copy Tables and Views" -> choosing table -> "Run Immediately" -> error = "MSJet engine could not find object 'Employees' ..."
Any ideas?
Minh Thong
September 12, 2002 at 8:38 am
Now I'm really going crazy ...
I have successfully transformed the Regions table of the Northwind database into Excel twice, but I cannot duplicate this success on any other table nor can I do it again on Regions, either. When I get to the TRANSFORM screen I see that only the first row of the table is being exported to column "F1" in the spreadsheet, but all other rows say "Ignore" and I can't seem to change this anywhere, even though I double-check every setting the script created for export is only writing the first field.
I'm pulling my effing hair out over here!!!
Phil 'Minh Thong' Holbrook
September 24, 2002 at 12:02 am
The spreadsheet must be set up as an Excel list, which means the first row must be the label for each column you want to export to. In the destination of the transformation the worksheet name with a $ on the end should be set as the table name and the column names from the first row of the spreadsheet should appear as field names.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply