GoDaddy Support

Importing Data into a SQL Server Database

This article only applies to Classic & Web Hosting. For more information, see What type of hosting account do I have?

You can import data from a delimited file into your shared hosting account's SQL Server database. If the data you want to import resides in a database elsewhere, you must first export its contents into a delimited file.

NOTE: Prior to importing data into your shared hosting account, you must set up a SQL Server database, along with the necessary tables and fields, to house the data. For more information, see Setting up a SQL Server Database on Your Hosting Account.

To Import Data Into a SQL Server Database

  1. Log in to your Account Manager.
  2. Click Web Hosting.
  3. Next to the hosting account you want to use, click Launch.
  4. In the Databases section of the Hosting Control Panel, click the SQL Server icon.
  5. Next to the database to which you are importing, click the Admin Tool icon.
  6. Enter the User Name and Password you used when setting up the database.
  7. In the Navigation panel, expand the Connection folder.
  8. Click Connect.
  9. Expand the Tools folder on the left and click CSV File Import.
  10. From the Database drop-down menu, choose the database in which to import your data, and then click Next Step.
  11. From the Table drop-down list, select the table into which the data will be imported, and then click Next Step.
  12. Select the database columns into which the data will be imported, and then click Next Step.
  13. Choose the CSV file to import and specify the file's characteristics.

    NOTE: The max file upload size is 2.5 MB.

  14. Click Submit.
Rate This Article:
Related Topics:
NEED HELP? Call our award-winning support team 24/7 at (480) 505-8877

About GoDaddy

Submit

United States - English
Traffic Log Image