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).
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.