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, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources
Download trial Download trial Buy now, from USD 35 Buy now, from USD 35 SQL FILE IMPORT
Get our Products
Copyright © 2005 - 2019 Yohz Software, a division of Yohz Ventures Sdn Bhd.  ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
See help file See help file
How to upload files into a table in 5 steps.
Step 1
Enter the folder where the files are stored.
Step 2
Enter the database connection details.
Step 3
Select the table to store the files in.
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!
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 and start uploading files into your database in seconds.
Compare the feature set of different editions of SQL File Import.
Learn more about how SQL File Import can simplify your file upload work.