Easily import Microsoft Excel workbooks to any table
Simply drag a Microsoft Excel spreadsheet from Windows Explorer to WinSQL's catalog tree to import it into any table in any database.
Dragging an MS Excel file in WinSQL's catalog tab invokes the Excel import wizard, which allows you to:
- Import data from any MS Excel worksheet to any table in a relational database
- Since Excel workbook can have multiple worksheets, the wizard allows you to select a sheet that contains your data.
- Imported data can go in a new table or an existing table. In case of a new table, WinSQL will suggest a CREATE TABLE statement, which can be modified by the user.
Following images show a couple of screen shots in this wizard.