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
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.
