While bulk copy and other bulk import options are not available on the SQL servers, you can import a CSV formatted file into your database using your web browser.
You first need to create a table in your database in which you will be importing the CSV file. After the table is created, follow the steps below.
- Open up your web browser and login to your database with myLittleAdmin
- Expand the Tools folder in the left pane and click on CSV Import Wizard
- Select Database name, Table name, and columns you will be importing your file to
- Click the Browse button and locate the CSV file on your local machine
- Navigate to the Options tab and select the appropriate options for fields formatting, depending on how your file is formatted
- Click the Import button
Article ID: 770, Created On: 2/17/2010, Modified: 5/25/2010