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!