SQL File Import - Product Overview

CONTACT US

 568-3-53 (3rd Floor) Kompleks Mutiara 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia  6012-9714904  support@yohz.com  https://www.yohz.com

RESOURCES

 product blogs  video tutorials  help files

Support Email sales Email support Contact details Manual trial activation License activation

Get our products Download our products Buy from our store Referral program

How to upload your files into a table in 5 simple steps STEP 1: Enter the folder where your files are stored STEP 2: Enter your database connection details STEP 3: Select the table to upload the files into STEP 4: Point-and-click to map the file details to the target columns STEP 5: Run the task, and you’re done! Now that’s a little unrealistic. I mean, who just uploads files into a table which don’t link to anything? What if, the first 4 digits of our file represents a customer ID. What if, we now extract and upload the customer ID value too? You can accomplish this easily by using a script that extracts the first 4 values of the file name and uses that value as the input to the customerID column. But scripting is for coders, and I’m a database administrator, you say. Well, here’s a simpler way then. Create a spreadsheet that contains the customerID in one column, and the file name in the other. In SQL File Import, select the spreadsheet as the data source. Map the columns in the spreadsheet to the table columns, and you’re done!

Upload files into your database (no coding required) using SQL File Import

• upload data from your folders, CSV definitions, or Excel spreadsheets • point-and-click interface to map columns • reduce storage costs and increase security using compression and encryption options • supports Access, Firebird, MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, SQLite, and ODBC data sources

Get started with SQL File Import Start uploading files into your database in seconds - try SQL File Import free for 14 days

Got a question? If you need help, or have any questions about SQL File Import, please get in touch. support@yohz.com

Download a free 14-day trial now, and start uploading files into your database in seconds.

Learn more about how SQL File Import can simplify file uploads.

Compare the feature set of different editions of SQL File Import.

Buy a Basic Edition license for USD 45, or a Professional Edition license for USD 95.

CONTACT US

 568-3-53 (3rd Floor), Kompleks Mutiara, 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia  6012 9714904  support@yohz.com  https://www.yohz.com

RESOURCES

 product blogs  video tutorials  help files

Upload files into your database (no coding required) using SQL File Import

How to upload your files into a table in 5

simple steps

STEP 1: Enter the folder where your files are stored

STEP 2: Enter your database connection details

STEP 3: Select the table to upload the files into

STEP 4: Point-and-click to map the file details to the target

columns

STEP 5: Run the task, and you’re done!

Now that’s a little unrealistic. I mean, who just uploads files into a table which don’t link to anything? What if, the first 4 digits of our file represents a customer ID. What if, we now extract and upload the customer ID value too? You can accomplish this easily by using a script that extracts the first 4 values of the file name and uses that value as the input to the customerID column. But scripting is for coders, and I’m a database administrator, you say. Well, here’s a simpler way then. Create a spreadsheet that contains the customerID in one column, and the file name in the other. In SQL File Import, select the spreadsheet as the data source. Map the columns in the spreadsheet to the table columns, and you’re done!