Importing from access database into multiple spreadsheets

S

Sandy

How can i import data from an access database into multiple spreadsheets
with limit of 2000. Any ideas or macros?

Thanks,
Sandy
 
R

reneabesmer

hiiiiiiiii hope u are ok
they one way that i know about how to export data from Ms access to Excel is
that when u have ur Data in Access or when u run ur Querry then plz go to
tools menu and then to Office Link -> in office like u will see Anaylze with
Excel , click on it
so u will export ur data 2 excel .
good luck
 
Top