|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 14th, 2004, 10:15 PM
|
|||
|
|||
active directory to SQL
Greetings
can anyone please tell me how I can import my companies list of employees, their dept, names etc into a sql table? I have been pulling my hair out on this one for sometime now.  thanks
|
|
#2
June 15th, 2004, 10:55 PM
|
|||
|
|||
|
Hi,
1.Create table in SQL with all the required columns according to the existing company data. 2.List all the company data in excel spread sheet with the column names (as in SQL table) in the first row in the same sequence of the SQL table columns with the data in the following rows. 3.Save the spreadsheet and exit from excel 4.In SQL, follow the import wizard and import the data from the excel spreadsheet. I hope u get some idea now.
__________________
Regards,  Brightlight
|
|
#3
June 16th, 2004, 03:07 AM
|
||||
|
||||
|
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > active directory to SQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
