SQL developer import text file

Asked By Thomas C Saucedo 30 points N/A Posted on - 11/24/2013

Hi Techyv experts,

I am using Oracle SQL Developer 3.0. It works nicely. But sometimes am Getting Problem in importing and exporting of text files. This creates a big trouble. So please help me to understand, How SQL developer import text file in SQL. Thanks in advance.

Regards,

Thomas C Saucedo

• Status: Open
• Question Views: 3962
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: General

Answered By Ropp Watson 0 points N/A #187792

SQL developer import text file

Hi,
A lot of options are available in which you can import external data to your SQL Server. Such options are Import & Export Wizard, OPENROWSET, SSIS, and BULK INSERT command.
Furthermore, you can also make use of xp_cmdshell to import text file to SQL Server. With this purpose, there is a need to utilize dos command TYPE. The image below shows a cript that can be used to import a text file to the database.
The following script requires xp_cmdshell to be enabled on server.

About Ropp Watson

Questions
0

Answers
17

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 11/29/2013
• Question Category: General