ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing from access database into multiple spreadsheets (https://www.excelbanter.com/excel-discussion-misc-queries/44304-importing-access-database-into-multiple-spreadsheets.html)

Sandy

Importing from access database into multiple spreadsheets
 

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

Thanks,
Sandy

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


"Sandy" wrote:


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

Thanks,
Sandy



All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com