exporting data to excel from and adp

  • Thread starter Thread starter Andreas Wöckl
  • Start date Start date
A

Andreas Wöckl

Hi Group!

I have the following problem:

All my forms are used in the same way - you have an overview of all data
(for example employees, custumers, jobs...) and a lot of custom filter to
manage the data. I am looking for an easy way to export the selected data (I
do the selection with setting the recordSource) to an excel sheet without
using a temporary table. I Know there is a possibility in Access (mdb) but
how to work with SQL Server.

I tried to create an sql string that would do the following:

"select * from qry_kontaktpersonen where (kontaktperson_nr=12 or
kontaktperson_nr=13 or kontaktperson_Nr=14....)"

With Docmd.OutputTo acOutputServerView, "..." it only works until the string
has a certain length

Anyone an idea?

thanks in advance

andreas wöckl
 
Your SQL could be shortened as

select * from qry_kontaktpersonen where kontaktperson_nr IN
(12, 13, 14 ....)

Hope This Helps
Gerald Stanley MCSD
 
hi gerald!

That sounds good - I will try and hope not to exceed the maximum length!

best regards

andreas wöckl

Your SQL could be shortened as

select * from qry_kontaktpersonen where kontaktperson_nr IN
(12, 13, 14 ....)

Hope This Helps
Gerald Stanley MCSD
 
Back
Top