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!

How do I Remove Field Titles

Status
Not open for further replies.
Bill4tektips

Bill4tektips

Technical User
Aug 5, 2005
175
GB
I have an Excel spreadsheet that I am populating from an Access 2000 query. Is there any way to get the query information without the field names at the top?
 
Sort by date Sort by votes
Check Access Help for the TransferSpreadsheet function. The fifth argument to TransferSpreadsheet is "Has Field Names" that dictates if field names will appear (or not appear) in Excel.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

YoBi4Ever
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
207
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
395
atadbitslow
atadbitslow
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
697
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top