Importing from Microsoft Excel

WinSQL provides a Microsoft^® Excel^® Import Wizard to use when importing data from an Excel spreadsheet into an existing table or a new table in your database.

Perform the following steps to use the Text Import Wizard to import an Excel worksheet:

1          From the Query menu, point to Import/Export, and then click Import From MS Excel. The following window displays:

Note: You can also invoke the Import Wizard by opening Windows Explorer, navigating to and selecting the Excel file you wish to import, and then dragging it to the WinSQL Catalog window.

2          Click Browse to navigate to the Excel workbook.

3          Click to select the file, and then click Open.

4          Click Next. A window similar to the following, containing a preview of the Excel data, displays:

5          If your workbook contains multiple worksheets, click the down arrow in the Desired worksheet field to select a worksheet.

6          Click Next

7          If you wish to import your Excel data into an existing table, select the Import to existing table option, and then click the down arrow to select the desired table

OR

Accept the default option, Import to a new table, to import your Excel data into a new table. If this option is selected, WinSQL will suggest a CREATE TABLE statement that you can modify, illustrated as follows:

.

Important Note: If you wish to change the name of the new table, type the desired name in the text field next to the Import to a new table option. Do not modify the table name in SQL script.

8          Click Next, and then click Finish.

WinSQL will read the Excel data and import it into the selected or new table in the database.