Importing Data into a SQL Server Database
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
- Log in to your Account Manager.
- Click Web Hosting.
- Next to the hosting account you want to use, click Launch.
- In the Databases section of the Control Panel in your hosting account, click the SQL Server icon.
- Next to the database to which you are importing, click the Admin Tool icon.
- Enter the User Name and Password you used when setting up the database.
- In the Navigation panel, expand the Connection folder.
- Click Connect.
- Expand the Tools folder on the left and click CSV File Import.
- From the Database drop-down menu, choose the database in which to import your data, and then click Next Step.
- From the Table drop-down list, select the table into which the data will be imported, and then click Next Step.
- Select the database columns into which the data will be imported, and then click Next Step.
- Choose the CSV file to import and specify the file's characteristics.
NOTE: The max file upload size is 2.5 MB.
- Click Submit.
Rate This Article:
74 People Found this Helpful
Related Topics:
Related Articles:
What are the Database Publishing Service and Database Publishing Wizard?
Importing MS SQL 2005 Databases into MS SQL 2008 Databases
What version of SQL Server is supported by the Database Publishing Service and Database Publishing Wizard?
What should I be aware of when using the Database Publishing Service in the hosted environment?
Limitations of the Database Publishing Service in the Shared Hosting Environment
What does my Database Publishing Wizard error mean?
Where can I get more information on the Database Publishing Wizard client?
Importing MS SQL 2005 Databases into MS SQL 2008 Databases
What version of SQL Server is supported by the Database Publishing Service and Database Publishing Wizard?
What should I be aware of when using the Database Publishing Service in the hosted environment?
Limitations of the Database Publishing Service in the Shared Hosting Environment
What does my Database Publishing Wizard error mean?
Where can I get more information on the Database Publishing Wizard client?
Sending Message...Have a question about the content of this article?
0 min expected wait time