Importing Data

R

Roger

I have two questions. 1. is can i import data from an Access database by
queries, or do I have to combine several queries to one and than import the
data. (what i have is information in queries by region, than I want to put
that information into a spreedsheet). 2. Some of the field are an yes/no
reply and I want to bring them over and replace if yes with a 1. this way I
can total each row than.

thanks
 
M

Miguel Zapico

1. You can create the query you need with the import data wizard. If you are
not familiar with MS Query, creating the query in Access may be easier, but
it usually can be done in both places.
2. There is no need to translate the Yes/No, you can use COUNTIF instead of
SUM to get the total of "Yes" at the end. If you still have to do it, it is
usually better do it in the query before importing, Access can do this things
well.

Hope this helps,
Miguel.
 
Top