1. Open your Excel file.
2. Once your worksheet is selected, go to the 'File' menu and select 'Save As'.
3. Once you have saved each of your Excel worksheets separately into CSV format, you are ready to utilize phpMyAdmin's import functionality.

1. Install the latest MySQL ODBC drivers:
2. Open the 64 bit ODBC Administrator:
3. Open the System DSN tab and click Add:
4. Choose the latest MySQL ODBC driver and click Finish:
5. Enter the ODBC credentials:
6. Test the data source connection:

1. Go to Tools->Options.
2. Query Results->SQL Server->Results to Grid.
3. Check “Include column headers when copying or saving results”
4. Click OK.
5. Note that the new settings won't affect any existing Query tabs — you'll need to open new ones and/or restart SSMS.

1. Step 1: Select Excel as your file type.
2. Step 2: Choose the Excel file you want to convert to SQL.
3. Step 3: Select whether the first row contains data or column names.
4. Step 4: Type the name of the Excel worksheet that holds your data.

1. Log in to cPanel.
2. In the DATABASES section of the cPanel home screen, click phpMyAdmin:
3. In the left pane of the phpMyAdmin page, click the database that you want to import the data into.
4. Click the Import tab.
5. Under File to Import, click Browse, and then select the dbexport.
6. Click Go.

1. Confirm that SQL is selected under format.
2. Click “Go”.
3. Type the file name and select the directory where your exported database is to be saved in the 'Save File' dialogue box on your local computer.
4. Click “Save” and the process of exporting will start.

1. In Excel, click the File tab.
2. Click Options > Trust Center > Trust Center Settings, and then click External Content.
3. Click the option that you want under Security settings for Data Connections:

1. Select Data > Get Data > From Database > From SQL Server Analysis Services Database (Import).
2. Enter the Server name, and then select OK.
3. In the Navigator pane select the database, and then select the cube or tables you want to connect.

1. Right click the ribbon and click on customize the ribbon.
2. Next select main tabs from the choose commands from drop down box.
3. Expand Data and Add the options you need.

1. Click the Execute SQL button on the XLTools tab. The editor window will open.
2. On the left-hand side find a tree view of all available tables.
3. Select entire tables or specific fields.
4. Choose whether to place the query output on a new or an existing worksheet.
5. Click Run.

Creating an ODBC Data Source

1. Select Start, Control Panel, Administrative Tools, Data Sources (ODBC).
2. Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box.
3. Select SQL Server as the driver for which you want to set up the data source.

1. Open Microsoft Excel.
2. Select the Data tab.
3. Click From other sources.
4. Select From Data Connection Wizard.
5. Select Microsoft SQL Server.
6. Click Next.
7. Enter the SQL Server Name.
8. Select credentials to use.

1. Restrict the amount of data that you request from the server.
2. Use only the functionality that you need.
3. Create linked (attached) tables to access server data.
4. Design list boxes and combo boxes wisely.
5. Avoid large combo boxes.

1. Click Start, and then click Control Panel.
2. In the Control Panel, double-click Administrative Tools.
3. In the Administrative Tools dialog box, double-click Data Sources (ODBC).
4. Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add.
5. Click Add.

1. Run MS Excel and click the Data tab.
2. To import data, click From other sources and then select From data connection wizard.
3. When Data Connection Wizard opens, select ODBC DSN and click Next to continue.
4. Now you should select a data source you want to connect to (e.g. NetSuite).