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
Point-and-click to map the file details to the target columns.
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 ImportStart 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 firstname.lastname@example.org
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.