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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA code to export an Access table to Excel

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Does anyone have VBA code to export an Access table to Excel?

Thanks in advance.
 
Sort by date Sort by votes
Try DoCmd.TransferSpreadsheet

You can determine the version of Excel and whether or not you want field names sent into the spreadsheet. It makes exporting very easy for things like tables and queries.

Hope that helps.

Bob

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
484
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
509
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
361
Viswa.R
Viswa.R
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
759
Knicks
Knicks

Part and Inventory Search

Sponsor

Back
Top