The import of data is the automated or semi-automated input of data sets between different software applications.

learn more… | top users | synonyms (1)

1
vote
1answer
645 views

Importing a Foxpro Database

I have a Fox Pro database (one DBC and a bunch of DBF files) that I want to import into SQL via the Import and Export wizard. I downloaded the FoxPro ODBC driver. I managed to get to the screen that ...
1
vote
3answers
622 views

Fastest way to do bulk import in MYSQL

I have got a question about the fastest way to copy a large number of records (around 10 million) from 1 table to another in MySQL. The target table has 1 primary key, 4 indexes and 3 foreign key ...
0
votes
1answer
2k views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
4
votes
3answers
2k views

Can you time how long an Oracle import takes?

I'm on a Windows machine with Oracle Client 11.1.0, and am going to import a database dump. I'm importing from the command line with the "imp" command. Is there an option to time how long the import ...
0
votes
2answers
301 views

Whats the best and fast way to import a huge DBF file to a Postgres in Windows?

I have some huge DBF files (about 35 GB) to import to Postgres. Whats the best and fast way to do it? OBS: I have 300 GB of free disk space and 8 GB RAM.
0
votes
3answers
2k views

mongoimport error - Failed: error connecting to db server: no reachable servers

I am currently trying to learn mongodb and I am having trouble finding a solution for this problem. When I run a mongoimport command it I get the following error: ~ mongoimport --host localhost ...
2
votes
2answers
1k views

Oracle Data Pump Import imports no records

When we do an Oracle Data Pump import of our database, it runs without significant errors. However, on one table Oracle reports that 0 records have been imported. Processing object type ...
7
votes
1answer
396 views

Why is a .bacpac file so small compared to a .bak file of the same database?

I've been doing backups of my SQL Server 2014 Express databases for import to other servers and noticed a difference in file size between .bacpac and .bak. Why is a .bacpac file so small compared to ...
0
votes
1answer
170 views

Can I do an impdp with a file on my local computer

I was given a dump file which is currently on my local computer. I want to import this to our Oracle 11G DB which is hosted on a server. Do I need to move this file to the server to do the impdp or ...
0
votes
1answer
619 views

Operation failed with exitcode 1 - while importing from a dump folder

I'm new to dbs and I'm trying to learn how a certain db works. They gave me a dump folder to play with it but, after setting up a connection (works), while trying to import, I get this annoying ...
1
vote
0answers
17 views

What file format are these files?

I am trying to import tables from an unknown DBMS. The file extensions for a table end in -nothing-, .d and .k. Presumably there is a table file, an index file and a memo file (like FoxPro uses) but ...
1
vote
0answers
22 views

How can I import data from a NetCDF file into SQL Server?

I'm being asked to investigate the feasibility of importing data from a NetCDF file into SQL server. The file could be upwards of 300-400Mb and provided 4 times a day. However I'm only interested in ...
0
votes
2answers
285 views

How do I determine the appropriate size for my tablespace when importing a .dmp file?

I have a 14g DMP file. How large should I size my tablespace to import it into an Oracle 11g database?
2
votes
4answers
3k views

Why would SequelPro only import 23k rows out of 130k?

I use SequelPro for MySQL on a Mac OS X. I used the import function to upload a 130k .csv file to my database. Everything seems to work fine, then I get the message: File Read Error: An error ...
1
vote
1answer
39 views

import TSV file into MySQL table with SET datatype column

Is it possible to use LOAD DATA INFILE to load data into a MySQL/MariaDB table, where one column uses the SET datatype? My columns are separated by tab, my set members by comma. If so, how do I ...
1
vote
1answer
35 views

Importing .dmp file into SQL developer: Do I need to import seperately for each table?

I have a large .dmp file which I would like to import into SQL developer. This contains all the data I want to import across several Schemas. Do I need to split this up into each separate table in ...
4
votes
1answer
3k views

How to import export.sql in sql developer?

In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard. So that is export. It creatres export.sql file. Now how to do import ? I am usgin SqlDeveloper ...
2
votes
2answers
826 views

Importing CSV file using SQL Server Import and Export Wizard (SQL Server Express)

So I am having a heck of a time importing a CSV file. The ultimate goal is to create a repeatable process to import the file. The only way I've been able to import the file is in a roundabout way ...
0
votes
2answers
5k views

Where .dmp file is restored after import in oracle?

I am new to oracle and I have abc.dmp file at c:\abc.dmp location. I want to import this abc.dmp file. I am using the following command. c:\>imp system/mypassword file=c:\abc.dmp full=y I am ...
1
vote
1answer
203 views

After Insert Trigger never fires using Import Wizard

Using Import Wizard I tried importing tables tcc_Block and PROJECT_IDENTITY. These 2 table structures already exist in SQL Server and they are related with ProjectID columns. PROJECT_IDENTITY has ...
2
votes
1answer
1k views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
0
votes
2answers
3k views

Oracle schema import is not importing all the tables present in the schema dump file

I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
0
votes
1answer
253 views

Trying to phpMyAdmin import a database with a different name

I've been searching for answers and couldn't find anything suited for my exact situation : I have a magento website and i'm trying to "duplicate" the website into another one selling other types of ...
1
vote
1answer
38 views

Importing Oracle12c database

i am using Oracle 12c in debian Jessie i want to import an old database exported with expdp on oracle 12c when i try to launch the commande 'impdp' i got those errors : 'ORA-39002: invalid operation' ...
0
votes
0answers
27 views

Load Multiple images (BLOBs) into the Oracle Database

I have a folder with several images. My database table is a simple table with 2 fields: name (char) and image (BLOB). How can I import my images located in my C disk (e.g.: C:\Users\me\images) into my ...
1
vote
2answers
64 views

Ignore empty rows while loading data into a table

I created a table (tbldemo) with 22 columns using a CREATE TABLE statement in MySQL. When trying to insert the data from a .csv file using a LOAD DATA INFILE statement, I get this error: Error ...
0
votes
1answer
31 views

MS Access Data Type for time in hh:mm:ss format

My database contains three different sporting events with finishing times imported from an Excel spreadsheet in the hh:mm:ss format. How do I customize the Access data type field to accept this ...
12
votes
7answers
86k views

How to import a .sql file in MySQL?

I am trying to import a .sql file using MySQL Workbench and I get this error: ERROR 1046 (3D000) at line 28: No database selected I have first created an empty database called with the same name as ...
5
votes
1answer
756 views

Get minimal logging when loading data into temporary tables

Even after reading The Data Loading Performance Guide , I am still unsure if its necessary to add the TABLOCK table hint to an empty temporary table, defined with a clustered index in order to get ...
3
votes
1answer
67 views

Converting standard_conforming_strings from off to on when importing Postgres dump

I've got a Postgres 8.1 instance which has standard_conforming_strings set to off (== handles slashes as escape characters). Recent Postgres versions have this setting on by default (for good ...
1
vote
0answers
22 views

How to add in carriage-return/line-feeds without starting a new row in a tabbed txt SQLite import

I'm using a tab-delimited .txt file to save my data before importing it into a SQLite database with the SQLite Manager add-on for Firefox. I've tried a couple of ways to add ...
2
votes
2answers
6k views

Using OPENQUERY to execute a script

I have a SQL Server 2008 instance which I want to use to import data from an Oracle server. I have set up a linked server that works correctly when running simple queries like SELECT * FROM table. ...
0
votes
0answers
7 views

Restore database exported with database_to_xml

I've exported a database to a XML file using the database_to_xml command found in documentation. Now I want to perform the opposite task. I want restore the database from an empty one using this XML ...
1
vote
0answers
573 views

SQL Server 2014 Import Wizard missing data source option

I have already run the upsizing wizard from my production Access 2010 .accdb database to create all the table structures and move the data on to our new SQL Server 2014. This included adding some PKs ...
0
votes
0answers
18 views

Load DATAINFILE extremely slow

I am using the code below to insert a 2.2MB file into a MySQL database in the cloud using Azure (the free version) with 36 thousand rows and 8 columns of doubles. MySqlCommand sqlCmd = new ...
0
votes
0answers
42 views

Importing Legacy Files directly into SQL Server database

I have a bunch of flat files, mostly Excel files, which I am trying to import directly into a SQL Server 2012 database. Is there a way to do this? I assume first the columns in the Excel files must ...
0
votes
1answer
45 views

Postgres Data Dump problem

I am trying to dump this data into Postgres: COPY address_types (game_id, device_type) FROM stdin; 1 Ps3 2 Xbox 3 Other \. But I always get this error: [Err] ERROR: syntax error at or ...
1
vote
0answers
11k 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
vote
1answer
38 views

Importing CSV file - PostgreSQL 9.2

I'm trying to import data from a CSV file on a PostgreSQL 9.2 server, but I get errors when doing that. Pgadmin: ERROR: Cannot execute COPY FROM in a read-only transaction Why am I getting that ...
0
votes
2answers
27 views

Importing mysqlnd database to MySQL server

Importing a mysqlnd (5.0.12) database to MySQL server (5.1.66) causes error? Currently we are performing this task and encountering errors (like below): ERROR 1146 (42S02): Table 'xx-xxx-xxx-xxx' ...
2
votes
3answers
75 views

Date conversion and integer truncation during import

I am doing some data file imports using: LOAD DATA INFILE 'apa.txt' INTO TABLE Test_Stock_Daily FIELDS TERMINATED BY ',' (symbol, date, open, high, low, close, volume); The date in the file is ...
0
votes
1answer
59 views

MySQL Database import into 5.7 hangs with CLI or with Workbench 6.3 CE

I have a SQL dump file that I exported using Workbench from a server that is being decommissioned. The host and target OS is Microsoft Windows Server 2008 R2 (therefore is x64 natively). There seems ...
0
votes
0answers
64 views

Can Firebase serve as my DB-driven app's primary DB (and if not, what's a good choice)?

I've created a data scraping workflow that creates .csv files. I've been populating a Postgres DB with those .csv files thusfar. After a contractor failed to successfully develop a REST API to query ...
0
votes
1answer
140 views

Load data from flat file into oracle table [closed]

I created a new database, then created a table "users". Now, I'm trying to load data to this table from a flat file called 'users.tbl', that has some records with the following format: ...
1
vote
1answer
61 views

SQL Data in form of Date+Time bulk insert into one column

Background of problem: To insert 2 seperated fields of data (from a big flat file document of data) with bulk insert. Columns in question that i want to get data from is in its current form in date ...
0
votes
2answers
32 views

Excel Import ID, Data Type Double

I get a file from another department that contains an id column. The id column is mostly numbers, but also contains some letters. I receive the file in XLS format. When I try to use the import ...
0
votes
0answers
21 views

XML to Database with XMLSpy

I am using XML Spy to take a XML file (looks like this) and create a database structure after it. I then import the data from my XML file to fill in the rows, etc. I find that some , about 1/4 of the ...
0
votes
1answer
112 views

Selecting from a table contains a XML column

I have received an Excel file (verion 2010) and based on the requirement I was asked to save it as an XML file and then import into SQL data ready to be queried in normal SELECT statements. Below is ...
4
votes
1answer
189 views

Mysql LOAD DATA INFILE 100,000 csv records perfect BUT 300,000 records - 0 rows inserted

The following query imports 100,000 perfectly, but larger files nothing happens. No errors, no rows loaded. Any clues you can offer are appreciated. I spent hours looking into max file and memory ...
3
votes
1answer
79 views

SSMS: Import from flat file (.csv)

In SQL Server Management Studio (SSMS) 2008 R2, I wish to import a not-quite-properly formatted CSV into a database table. I was trying to use the wizard at <database name>->Tasks->Import Data. ...