I need to import few columns from csv file into firebird temp table but not using any tool only from sql editor aka openrowset in SQL server. is it supported? thanks
Asked
Active
Viewed 1,356 times
1
-
You could write a script that turns CSV into SQL `insert` statements and execute that. Anyway **never trust the input, check and sanitize**. – Stefano Sanfilippo Sep 12 '13 at 19:23
-
http://stackoverflow.com/q/8213/62576 – Ken White Sep 12 '13 at 19:27
-
What do you mean with "only from SQL editor"? Which SQL tool are you using? – Sep 12 '13 at 19:39
-
I use EBEasy+ and SQL Manager lite for firebird – Zulu Z Sep 12 '13 at 22:00
-
hard to believe firbird doesn't hsave load statement or something like that... – Zulu Z Sep 12 '13 at 22:00
-
@ZuluZ Firebird has external tables, but the dataformat is a binary format – Mark Rotteveel Sep 14 '13 at 07:34
2 Answers
1
firebird doesn't have a load statement, but several tools have an import module. Easest is to edit the file into a set of insert statements
NickUpson
- 146
- 2
1
You can have look at Data Transformer (disclaimer - I'm its developer). It can convert between CSV (an other formats) to SQL. The generated SQL contains "insert" statements for each line and a "create table" statement.
It works offline - the data never leaves your computer.
You can get it from the Mac App Store or the Microsoft Store.
Geo Systems
- 101
- 6