0

I have 100 .xslx and .xls files with different formats and I need to import them all separately into Access keeping their original file names intact.

Folder example: C:\Users\username\Desktop\2019_data\foldername\

sample names of the many different sheets in the folder=

LGPO221154-1-ANDERSON-CELL 18-49.xlsx LGPO221154-1-ANDERSON-CELL 50_UP.xlsx LGPO222975_1_CELL_49_UNDER_Bandera.XLS LGPO222975_1_LL_49_UNDER_Comal.XLS

Juan Zendejas
  • 1

1 Answers1

0

I haven't done MSSQL in a while but if I remember you can do a ssis package. I think its part of sql management studio. Where you can read in files and do inserts.

newdeveloper
  • 133
  • 1
  • 6