How to import users from Excel sheet?

Asked By 40 points N/A Posted on -
qa-featured

 

Hi to everyone,

How to import users from Excel sheet? I got fifty username in mysql server database and needs to be recorded in an excel sheet for backup record. Is there a way that I can automatically import those username directly to Microsoft Excel? Give me some knowledge about this matter.

Your suggestion is very much welcome.

SHARE
Best Answer by Ywain Jamin
Best Answer
Best Answer
Answered By 0 points N/A #184977

How to import users from Excel sheet?

qa-featured

 

Yes it is possible. here are some steps: 
 
  1. First In Excel open the Data Source by clicking DATA > IMPORT EXTERNAL DATA > IMPORT DATA 
  2. Then you need to configure MySQL ODBC driver by Clicking START >CONTROL PANEL > SYSTEM AND SECURITY > ADMINISTRATIVE TOOLS > DATA SOURCE (ODBC) 
  3. Click on New Source button, select Other/advanced and click Next. 
  4. Select connection tab and fill unnecessary infos. 
  5. Click on Test connection tab and Test Button to make sure that everything is connected and working well 
  6. Now select the MySQL table that you want to Import and click Next. 
  7. Add info and click Finish. 
  8. In the next window select the data source and click OPEN 
  9. The next window will ask you if you want to save the data in an existing worksheet or anywhere else. Choose existing worksheet. 
  10. Click OK. 
The data table from MySQL should now be imported into the excel sheet. 
Hope this helps!
Answered By 10 points N/A #184978

How to import users from Excel sheet?

qa-featured

Hello Raine, 
 
You can do this thing by simply exporting from the SQL server. If you just export it you will get the exported file in *.csv which is a format of MS excel or spreadsheet.  
 
Now as you wanted to connect automatically the database with an excel file than follow the steps. Go to data tab in MS Excel. In connection section you will get an option “connections”. Click on that and a box will appear. Now from the left side select add. Another box will appear there give the server name then fill up the fields the database will connects to the MS 
Excel file directly. Your data will store in your Excel file automatically. 
 
Thank you, 
 
 Riley Weaver.

Related Questions