insert data from a table to Excel 1

[itmasterw]

Hi,
I am trying to put the data from a table into an Excel spreadsheet. People I work with said that they have done something like the following, but are not quite sure of the systex. THey said this should create the spreadsheet and insert the data. However, no matteres how I do this it comes back with either "incomplete query cluase" Or " Syntex error. I think I can do this with loops, but if I can get this statement to work it would be better.

Here is the code I have:

SQLStr = "SELECT * INTO '[Excel 8.0; Database = G:\APPO\MerlsS2.XLS].[Sheet1]' FROM tblFinalOut"
CN.Execute SQLStr

Any ideas would be greatly appreacted.
Thank You

 

[reneford]

Try this:

SQLStr = ("SELECT * INTO [Excel 8.0;" & "Database=G:\APPO\MerlsS2.XLS].[Sheet1]" FROM tblFinalOut")

 

[itmasterw]

Thank you, that did it.