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 derfloh 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
Joined
Jan 1, 1970
Messages
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

Knicks
  • Question Question
Nested Column (Excel, CSV) : How to extract just the metadata or column names within a column of data
Replies
1
Views
70
Andrzejek
Andrzejek
FrankMars
  • Locked
  • Question Question
Exporting Records to Excel
Replies
6
Views
997
Andrzejek
Andrzejek
M
  • Locked
  • Question Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question Question
Filter vba problem
Replies
1
Views
936
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question Question
Dimension import from Autocad to Excel
Replies
0
Views
691
Viswa.R
Viswa.R

Part and Inventory Search

Sponsor

Back
Top