Import multiple excel files in one go

SQLServerCentral » Latest topics

Import multiple excel files in one go

Hi all,

i have around 50+ excel spreadsheets with 1 sheet in each, the same headings but varying amounts of data from 1000 rows to 5000 plus.

is there a way to reference a file location and import all the data in that one tab for each sp

more info...