Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Best Way to Import Multiple Spreadsheets (http://www.go4expert.com/forums/import-multiple-spreadsheets-t4666/)

Pamela Flad 13Jun2007 20:00

Best Way to Import Multiple Spreadsheets
 
Has anyone worked with multiple spreadsheets that needed to be imported into an Access database? What is the simplist/best way to combine the spreadsheets prior to importing them. Or would it be better to create a macro that automatically imports the multiple spreadsheets one by one (going to the same table in access).

shabbir 13Jun2007 21:41

Re: Best Way to Import Multiple Spreadsheets
 
When you import it has the options as far as I remember. Try your hands on and you will see the option available.


All times are GMT +5.5. The time now is 14:37.