exporting filtered records

[WaltLukeIII]

I have a table that has thousands of records I want to export only a selected group of those records. Specifically those records that are filtered and shown on a form I tried using a select statement in an export spreadsheet coomand as follows but could not get it to work. <br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dim querystr As String<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>If Right(path, 4) = &quot;.xls&quot; Then<br>querystr = &quot;SELECT * FROM [Quoted Parts] _&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE

= &quot; & numero1<br><br>DoCmd.TransferSpreadsheet acExport, 5, querystr, path, -1<br> <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[jimmythegeek]

The TransferSpreadsheet method will not export a SQL statement. It will however export a table or query, so just save your SQL statement as a query, and then put the query name in the TransferSpreadsheet statement. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development