Đã hoàn thành

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.

Kĩ năng: Bất kì công việc gì, Microsoft Access, SQL, Visual Basic

Xem nhiều hơn: open-table, data struture, table, sql import, import sql, import excel, excel to sql, excel to app, excel app, c# import excel, c import excel, batch, batch file, excel database visual basic, app basic excel, visual basic database excel database, app table, excel can open file, batch batch excel file, database table design, excel sql create, import files folder, point excel, batch open excel file, create application excel

Về Bên Thuê:
( 1 Nhận xét )

ID dự án: #1751414

Được trao cho:


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

$200 USD trong 1 ngày
(0 Đánh Giá)