Importing flat files (e.g.) Excel directly into SQL Database
10 replies · 2K views · last reply
Discussion
- 13,973
- 16,894
If memory serves BULK INSERT imports files wholesale. No idea what file formats it supports, except I used it for CSV.
Mentor
- 15,842
- 10,734
Mentor
- 15,842
- 10,734
Borg said:Since I'm a Java programmer, it would be a Java application. Probably no more than a hundred lines of code depending on how complex the differences are between the files and the database.
It could be Groovy too. Its a lot cooler than Java and all its formalism. Just sayin...
Mentor
- 15,842
- 10,734
No really, groovy is something you'd like its java as a scripting language. It has some things in it that you wished java had but doesn't. I've used it to protoype developer tools that used our project libraries but were easily reconfigurable.
But I digress... so as not to derail the thread in other paths...
But I digress... so as not to derail the thread in other paths...
Science Advisor
Gold Member
- 2,413
- 5,293
Sounds like it might make a good Insight article.jedishrfu said:No really, groovy is something you'd like its java as a scripting language. It has some things in it that you wished java had but doesn't. I've used it to protoype developer tools that used our project libraries but were easily reconfigurable.
But I digress... so as not to derail the thread in other paths...

Similar threads
- aheight
- · Replies 4 ·
- AI and Computer Science
- Replies
- 4
- ponjavic
- · Replies 5 ·
- Computing and Technology
- Replies
- 5