546 Batch Excel Files to SQL Table

I have hundreds of excel files that should have the same column struture in one folder. I need a batch application that I can point to the folder and point to a sql database. The app will open the first file to create the design of the sql table and the table can be named anything as long as i know what it is. From there, it will import all data from all excel files in that folder into the sql table as well as an extra column in sql to contain the actual filename of the excel file. this app needs to be able to handle all versions of excel because there are a mixture of files that are excel 2.1 and higher.

Taidot: kaikki käy, Microsoft Access, SQL, Visual Basic

Näytä lisää: data struture, table, excel app, batch, excel database visual basic, app basic excel, app table, database table design, excel sql create, import files folder, point excel, batch open excel file, create application excel, excel data table, sql app, create sql database, create app excel file, batch import excel database, app excel file, create database excel table, app excel, open table, batch file import excel, open table app, batch import excel

About the Employer:
( 1 review )

Projektin tunnus: #1751414

Myönnetty käyttäjälle:


Please see PMB for detail. Thanks, Raheel, Sharpeffect Systems.

200 $ USD 1 päivässä
(0 arvostelua)