I'm looking for a way to bulk insert data from an excel sheet to a table in the database (eg. SQLServer). Didn't find any solution to do it (that is not to save as a CSV or txt file). Any suggestions? thanks
Asked
Active
Viewed 935 times
-5
-
1You haven't looked hard enough – user1231232141214124 Aug 06 '14 at 14:27
-
There are several SO questions on this: http://stackoverflow.com/q/16818796/940217 – Kyle Falconer Aug 06 '14 at 14:27
-
Read Excel with `Apache POI` and write to db with `JDBC`. – PeterMmm Aug 06 '14 at 14:28
-
There are tons of answers on S.O. about this, and a simple Google will turn up APIs you can use also. – RossC Aug 06 '14 at 15:11
1 Answers
0
Hi you could have a ETL tool. extract transform load. Pentaho has free version of this. Hope it helps.
Lego_blocks
- 199
- 2
- 5
- 15