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

With ActiveX, I run a qry to get a

Status
Not open for further replies.
DavidSL

DavidSL

Programmer
Jul 7, 2003
15
US
With ActiveX, I run a qry to get a list of CustomerIDs. Then run a loop -- each time, pass one id into a sp and assign the return to a temp table. Then insert the data into an excel file (may split the data into more than one worksheets). If just one ID has been passed, it's ok. If multi IDs have been passed, it crushes. Can someone tell me the solution?
Thanks in advance!
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
156
tekpr00
tekpr00
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
195
drlex
drlex
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
248
gk53
gk53
ChewDoggie
  • Locked
  • Question
Help with Select statement Substring
Replies
2
Views
162
ChewDoggie
ChewDoggie
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
171
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top