Connecting to a comma separated file (CSV)

 

You may have all your employee information i a comma separated file, e.g. employees.csv located in k:\employees\.

 

In order to make sure that you can connect to this file, you need to use a special provider for that, and you can with success use:

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=k:\employees\;Extended Properties="text;HDR=Yes;FMT=Delimited";

 

 

You have to make sure that your file contains a column called 'accountname'. This field should contain your account initials, as this is the key to the Active Directory.

 

The content of your csv file could look like:

 

accountname,first,last,mobile,email,title

jd,John,Doe,0771234567,jd@company.com,Sales Manager

ls,Lisa,Sheppard,0777654321,ls@company.com,it supporter

Etc...

 

That is, 'jd' is the account initials for John Doe.

 

Now open the Command Centre for activeImport and put in the connection string to the text file. You do not need to put in the file name, only the path where this file is located and end the text with a '\'. Example:

 

 

The first row should always be the field names, otherwise will it not work. Click 'Test' to test and establish connection to the text file.

 

Now type in the file name in the "What is the View/table name" field:

 

 

Click 'Verify View' and the Command Centre will connect to the file and show how many fields are available in the file. Now you have established the connection and can continue with mapping the right fields.

 

---

Page url: http://www.officeaddon.com/help/index.html?connecting_to_a_csv_file.htm