Query disappears

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After Importing (from *.txt) then Exporting (*.xls) data the contents of my
query disappears. The query object does not get deleted but its substance is
gone. What is happening and how can this be fixed.
 
Import and Export pertains to data. If your query definition still exists,
but returns no rows, perhaps no rows meet the query's selection criteria?
 
The events that cause this phenomenon are a bit mysiterious. I do know that
the Import (which is done via a macro) and the Export (also via a macro) will
cause the query to "disappear".
The Export macro uses the query to do the export.
Also, the disappearing act will not happen if I simply look at the query in
Design/SQL view in between the Import and Export.
If I do the Import and export without looking at the query in between, the
query disappears.



The Import is probably insignificant. The point is that some action is
taken (
 
Sorry, I still don't have enough to hazard a guess from.

What happens if you run the query before Import?

Jeff Boyce
<Access MVP>
 
I don't respond to unsolicited emails -- I have no way to verify their
safety. And my work here in the newsgroups is voluntary, as is most
everyone else's. If you are looking for paid support, ... <g>

Keep the Q & A in the newsgroup, that all might benefit.
 
Back
Top