Use Save As or Save Query?

H

Historian

I've got an Access Database table with several thousand entries. I applied a
filter to get me a sub-set of entries that I want to export into Excel. When
I click Save As, it pops up with a box that's totally unfamilar to me. What I
think I need to do is save the new table I created with the filter as a
different name than the table I started from so I don't accidentally wipe out
previous information. But I'm clueless on how to do this. Help!

Thanks!
 
M

Maurice

My advice would be to create a query with the same filter applied as you did
in the table. When you clicked save as Access presumes you want to save
another copy of the table. When filtering data use queries instead. They can
be saved seperately and you can reuse the over and over again.
 
J

John W. Vinson

I've got an Access Database table with several thousand entries. I applied a
filter to get me a sub-set of entries that I want to export into Excel. When
I click Save As, it pops up with a box that's totally unfamilar to me. What I
think I need to do is save the new table I created with the filter as a
different name than the table I started from so I don't accidentally wipe out
previous information. But I'm clueless on how to do this. Help!

Thanks!
Click to expand...

Don't use Save As in this context. Just save the query as a query name, and
then use File... Export to export the query. Choose Excel as "file of type".

John W. Vinson [MVP]
 
Top