Yes, with a little work and some programming, you can import a CVS file to your database.
To prepare for the import first:
1) Download the latest copy of Microsoft SQL Server Management Studio (SSMS).
2) Obtain login credentials that grant you access to your database on the Tejon Tech server. If you don't already have these credentials, email us at email@example.com.
3) Obtain a share to you company's folder in the Tejon Tech's DropBox account.
Importing the CSV file
Once you're setup with access to the database, you can import your CSV file using these steps,
1) prepare your CSV file. Use comma delimiters, and don't use double quotes around the data.
2) Copy your CVS file to the Dropbox folder. It will automatically sync to the Tejon Tech server.
3) Using your credentials and Microsoft SQL Server Management Studio, log into the Tejon Tech server.
4) Create temporary staging table to receive your data.
5) Import you data using Bulk Insert.
6) Check the data.
7) Import the data from the staging table into the class view.
8) Check the data.