How to convert .sql ( opened into notepad) to .xls without sql server installed on your system.?

Question

i have an urgent file names and urgent.sql and i have opened it in notepad. Now i really want to convert the text data into the excel file so that the data can automatically divided into the table. sql server is not installed on my system.

as of now the the data in .sql file is like :

(`member_id`, `title`, `firstname`, `age`, `member_pass`, `address`, `city_id`, `state`, `zip`, `mob_number`, )



Now i want to convert this data in excel table .

I did copy and paste data from here to excel, but all the data is there only in one multiple row.

Rather i want this data to be spreaded in column.

column1 column2 column3 column4 column5 column6 column7
title first name age member addre city state



Friend i want your help in this please.

Answer 1

It looks like you have delimited text data. When you have copied and pasted it into an Excel column, you can use Data > Text to Columns to convert this to multiple columns.

Answer 2

Convert Sql To Excel

Answer 3

In step with the query on importing the Excel 2007 information to SQL Server 2005, I would like to provide you the ideas as follows: 1. Connection string hassle: Please examine in case you are able to attach each Excel 2007 and SQL Server 2005 as the information source effectively. The excelConnection seems to be to find as you supplied. Then that you could also add "HDR=sure" to indicate that the primary row contains columnnames, now not information. "HDR=No;" shows the reverse. This can preclude the primary row careworn when importing to the SQL tables. 2. Please experiment your ODBC SQL Server connection string so that the connection to SQL Server is correct. Besides the ODBC, that you can also use SqlConnection and execute the SqlCommand object with the statement that entails the excelConnection on your VB.Internet code, however now not simply combine the entire in a single SQL announcement. The next article indicates you the way in which: Import Excel sheet into table three. Except the above ways, which you could do not forget to use SqlBulkCopy category to import. The next article suggests you the example: Import Excel Spreadsheet data into SQL Server Database desk making use of SqlBulkCopy four. There's a KB article in MSDN on the subject. Despite the fact that the article is just not applied for SQL Server 2005, which you could also gain knowledge of on SQL Server knowledge Transformation offerings (DTS), Microsoft SQL Server 2005 Integration services (SSIS), SQL Server linked servers and SQL Server distributed queries. They're necessary on your work. How you can import data from Excel to SQL Server Hope that can aid you.

Answer 4

Import you data in ms access and then save the data in excel format.

Answer 5

It appears your data is in CSV (comma-separated value) format. Use Excel Import wizard and there should be a choice available to import a CSV file.