SQL developer import text file

Asked By 30 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #187792

SQL developer import text file

qa-featured

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.

Login/Register to Answer

Related Questions