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

Export Query That Includes "*" In QBE Field To Excel

Status
Not open for further replies.
dominicdunmow

dominicdunmow

Technical User
Jul 28, 2004
125
CA
Hi there,

Using "DoCmd.TransferSpreadsheet acExport, 8" I'm trying to export a query to an excel template.

The query is based on 2 others. With regard to one of the queries, the field names are not static as they are the result of a crosstab query based on user inputs so to include all the fields I have to use the "*".

However the use of the asterisk does not seem compatible with the transferspreadsheet function.

Can anyone advise on how ot get round this please?

 
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
257
dhookom
dhookom
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
196
OzFoxy
OzFoxy
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
781
strongm
strongm
Swi
  • Question
Select X of each variation of a field 1
Replies
8
Views
353
rashmibala
R
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top