Best Way to Import Multiple Spreadsheets

Pamela Flad's Avatar
Newbie Member
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's Avatar, Join Date: Jul 2004
Go4Expert Founder
When you import it has the options as far as I remember. Try your hands on and you will see the option available.