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).
When you import it has the options as far as I remember. Try your hands on and you will see the option available.