Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Recordset to Excel

Status
Not open for further replies.
paulcooke

paulcooke

Programmer
Dec 11, 2003
35
0
0
GB
Hello basically i've got a recordset generated from a SQL search and i need to allow the user to export this data found to an excel spreadsheet. Any ideas? Many thanks
 
Sort by date Sort by votes
HAve a look at the CopyFromRecordset method of the Excel.Range object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
You may also simply consider the TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
135
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
94
Viswa.R
Viswa.R
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
159
Knicks
Knicks
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel Password Protect Fail
Replies
5
Views
197
combo
combo
Kennelbloke
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
179
Kennelbloke
Kennelbloke

Part and Inventory Search

Sponsor

Back
Top