How to import users from Excel sheet?

Asked By Timothy Raine 40 points N/A Posted on - 12/11/2012

 

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.

• Status: Open
• Question Views: 1001
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Ywain Jamin

Go To Solution

Best Answer

Best Answer

Answered By Ywain Jamin 0 points N/A #184977

How to import users from Excel sheet?

 

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!

About Ywain Jamin

Questions
2

Answers
30

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: MS Excel

Answered By Riley weaver 10 points N/A #184978

How to import users from Excel sheet?

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.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 12/17/2012
• Question Category: MS Excel