The csv-file tag has no wiki summary.
0
votes
0answers
13 views
how to import .xls file into SQLite database?
I have an issue with importing .xls file into SQLite database. I am working on windows xp and using a SQLite manager for maintain the database. I can import the .csv file to the database by using ...
-1
votes
0answers
45 views
Import 4 million rows
Hi I need to import about 4 million records into my DB. The file is a csv. I have tried MyAdminphp and it times out. Then i tried Razor SQL and it's way too slow. Any suggestions for handling this ...
0
votes
1answer
58 views
Dealing with empty strings while loading a table from a CSV
I am trying to load a CSV file into a table. The CSV file contains some empty strings for example:
1,2,,4
I want to load the empty field as null. One way I know is to use \N i.e:
1,2,\N,4
but it ...
1
vote
2answers
125 views
Loading data in mysql using LOAD DATA INFILE, replication safe?
I am trying to load data into mysql database form CSV file. I found that we could use LOAD DATA INFILE command to do it. But as per the mysql documentation it is not replication safe. (See here)
Is ...
1
vote
1answer
114 views
import csv data stored in a blob column
Here's what i need to do:
Users will upload CSV files into SQL Server 2012 blob column
Each night, i would like to take each file and import the data into table
I will have 2 web sites using the ...
0
votes
1answer
46 views
Set field values to newly imported rows in PostgreSQL table with existing data
I have a PostgreSQL table with existing data, and needs to import all the rows in a CSV file into that table. I am using pgadmin3's Import tool to do the import.
Question: For the newly imported ...
0
votes
1answer
76 views
Getting error while importing large data through csv
I am new Postgres. I am getting constraint violation errors while importing a
large CSV file.
I want to disable all of the database constraints temporarily - I do not know how to do this.
1
vote
1answer
129 views
Update oracle sql database from CSV
I tried google at first but no luck.
Is it possible to update tables from csv file?
I am using SQL developer and I am using a script to export edited rows to a csv file. I would like to update the ...
1
vote
1answer
351 views
Command line export and import CSV in SQL Server 2008 R2
I have a database xyz and 100+ tables and has to perform the following operations on the command line:
I need to create CSV of all tables in one go.
CSV with column separator ,, fields enclosed by " ...
0
votes
3answers
529 views
Export Postgres table on remote server to CSV file on local machine?
I have access to DB on remote server where I can do only select command,
So, I can execute:
COPY products TO '/tmp/products.csv' DELIMITER ',';
But on that server I don't have permission to ...
2
votes
1answer
109 views
Apply in a CSV file to multiple databases
Recently, I have been working with a client whom has asked us to provide their dataset for use in a mobile application we are making for them. The requirements for this project include the ability to ...
1
vote
0answers
82 views
Can PostgreSQL's COPY create CSV with Locale-specific number formatting?
I want to create a CSV with PostgreSQL 9.1 COPY that directly opens correctly with a double-click in crazy German Excel 2010. Using ";"-Delimiter is easy.
The encoding is solved, but Excel only ...
0
votes
0answers
193 views
Understanding the time difference between data grid initial display and export/full display using Toad for Oracle
I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...
0
votes
1answer
89 views
Permission Denied Copy [closed]
I am a beginner learning how to load data and I can't figure out why I can't load this data into postgres. I am using postgres 8.4 on MAC OS.
copy tname from '/Users/Shared/folder/file.cxv' ...
10
votes
1answer
1k views
Can I query a tab-delimited file from SSMS?
Is it possible to query a tab-delimited file from Sql Server Management Studio to view its data without saving it anywhere?
I know you can BULK INSERT from a tab-delimited file using something like:
...
2
votes
1answer
289 views
excel sheet input to mysql
I want to add about 1000 records to a table that contains 31 fields.
The worst part is those 1000 records are in the form of an excel sheet having some columns left unfilled. Is there any easy way to ...
4
votes
1answer
230 views
MySQL Import CSV with Multiple Field Separators
I'm trying to import this CSV file into MySQL that appears to be optionally enclosed by more than one character. Unfortunately, MySQL only supports one character as a field separator.
I am stuck ...
0
votes
2answers
577 views
Doing a comparison on two csv files with no Primary Key
I'm wondering if in SSIS there is a way to compare two csv files(with the same structure) with no reference key to make a record unique.
To give you a better picture from what I mean; In initial load ...
1
vote
1answer
253 views
How to troubleshoot COPY FROM inserting less rows then expected?
I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to wc -l, which I want to import using COPY FROM. I removed the table's primary key, so it has no constraints.
I ran COPY ...
2
votes
1answer
7k views
How to import a.csv file into a postgresql database using \copy?
I am trying to import a .csv file into a postgresql database. I am using pgadmin III for that on a win7 machine.
My query looks like that:
\COPY pop_grid(GRID_ID, POP_TOT, YEAR, METHD_CL, CNTR_CODE, ...
2
votes
0answers
153 views
Conversion of GRIB and NetCDF to my database [closed]
I have downloaded "High Resolution Initial Conditions" climate forecast data for one day. The file had an .tar.gz extension so I extracted it in my local directory and I get the files listed here:
...
0
votes
1answer
166 views
Which tools can be used to clean CSV files prior to bulk insert?
Which tools and programming libraries are you aware of that can help accelerate CSV manual correction process when column separator characters are encountered within data elements?
I'm currently not ...
1
vote
0answers
33 views
Import CSV file into SQLServer [duplicate]
Possible Duplicate:
Convert varchar column to datetime
Hi I am using the SQL server Import wizard to import a CSV file into what will be a new table in my database.
An example of the CSV ...
1
vote
1answer
223 views
Behavior of PostgreSQL COPY FROM
Let me preface this question by stating that my experience with DBA is limited to an introductory undergraduate university course, and that I'm just getting started with PostgreSQL.
I would like to ...
2
votes
0answers
69 views
sql data to a csv-file via cobol
I 'm using the following code :
string
'insert into ' delimited by size
'tgamGameTeams ' delimited by size
'(Id,Name,RemainingBudget,TeamGamePoints,GameId) '
...
1
vote
1answer
385 views
MySQL import csv only gets half the lines
I use the following command to read in a csv:
LOAD DATA INFILE '/Users/Tyler/Desktop/players_escaped.txt'
INTO TABLE players
FIELDS TERMINATED BY ','
ENCLOSED BY '^'
LINES TERMINATED BY '\n';
The ...
2
votes
2answers
3k views
MySQL - CSV UPDATE (not INSERT) into existing table?
I have a table with the following columns:
id | name | city
The table has 1000 entries in it.
I have a CSV file with a limited number of lines like this:
id,city
34,Denver
45,Kansas City
145,New ...
1
vote
2answers
439 views
Access exporting to CSV is weirdly slow
I have searched but could not find anything similar. If I just run the query, I can get the result pretty quickly (~5 mins); but after I saved the query to export as CSV, the exporting part is ...
2
votes
3answers
308 views
What's the easiest way to re-format CSV exports from MySQL into Excel/ flat-file fields?
I've just had some database backup problems on a website I run containing some important lead data. Unfortunately, I've now lost one of the key MySQL tables, which means my data has lost its ...
2
votes
4answers
128 views
Options for dumping Oracle queries to text files with no database server filesystem access
I've an application currently producing reports using UTL_FILE and DIRECTORY. We are migrating this application to an environment in which there will be no filesystem access on the database server ...
3
votes
1answer
4k views
psql denies access to file when using COPY FROM
When I do this:
COPY "mytable" FROM '/my/file.csv' WITH DELIMITER AS ',' CSV;
On this:
-rw-r--r-- 1 peter peter 54819176 2011-07-21 13:17 file.csv
psql tells me this:
ERROR: could not open ...
9
votes
5answers
5k views
Save Results as CSV *with* headers in SSMS
With SQL Server 2008 R2, when I save the results as a CSV there are no headers. I can work around this by copying and pasting with the "Copy with Headers" , or just grab the headers and paste them in ...
6
votes
1answer
189 views
How many disk seeks does it take to write one row on SQLite?
As far as I understand, there can be one disk-seek per rotation of a harddisk, therefore I am interested to know how many disk seeks are needed for writing a row to an SQLite table, including locking ...
