I am using the CSVJDBC driver for retrieving results from CSV files. All record fields are interpreted as Strings. How can I utilise the MAX aggregate function in order to obtain the maximim Integer of a column? As far as I know, csvjdbc does not support casting. Consider this sample file: I use the following code snippet: When I execute
Tag: csv
Can I use SQL commands (such as join) on objects in powershell, without any SQL server/database involved?
As a disclaimer, I’m no professional powershell scripter, but more of a ‘script-kiddie’ level scripter who was assigned something far outside the scope of his job, tech support. 😛 I’ve been working on a migration script to bring some really old data into a new software app. As a part of this, I’m using the following code to ‘Join’ two
Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
I’m trying to insert a large CSV file (several gigs) into SQL Server, but once I go through the Import Wizard and finally try to import the file I get the following error report: Executing (Error) Messages Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column “”Title”” returned status value 4 and status text “Text
OLEDB reading CSV file returns first column only
I’m trying to read a pipe separated text file. First lines are “BewerberID”|”Druck”|”Druckdatum”|”HistorieID”|”Bearbeiter”|”BewZuBewGruppeID”|”Bemerkung” “12586”|”EinladungOFD.dot …
How to update selected rows with values from a CSV file in Postgres?
I’m using Postgres and would like to make a big update query that would pick up from a CSV file, lets say I got a table that’s got (id, banana, apple). I’d like to run an update that changes the Bananas and not the Apples, each new Banana and their ID would be in a CSV file. I tried looking
Bulk load data conversion error (truncation)
I am getting this error Bulk load data conversion error (truncation) for row 1, column 12 (is_download) here is the csv…it only has one row 30,Bill,Worthy,sales,,709888499,bat@bat.com,,”Im a a …
How do I spool to a CSV formatted file using SQLPLUS?
I want to extract some queries to a CSV output format. Unfortunately, I can’t use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?
Generate insert SQL statements from a CSV file
I need to import a csv file into Firebird and I’ve spent a couple of hours trying out some tools and none fit my needs. The main problem is that all the tools I’ve been trying like EMS Data Import and Firebird Data Wizard expect that my CSV file contains all the information needed by my Table. I need to