N/APosted 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.
How to import users from Excel sheet?
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.