We can generate SQL statements using CONCATENATE function in Excel and execute those. This is much faster than using Import/Export Wizard.
Data in spread sheet is looks like below
Copy and paste the below formula in the fourth column to generate the formula ="INSERT INTO table_name VALUES('"&A1&"','"&B1&"','"&C1&"')"
To Apply this formula to all the columns Go to the corner of the column and drag it to column till formula needs to be applied.
Excel is a software program from Microsoft basic excel for beginners that is a part of Microsoft Office. Excel calculations is compiled for making and altering spreadsheets that are spared with a .xls expansion. It's general uses in corporate cell-based figuring, turn tables, and different diagramming devices. With an Excel spreadsheet, you could make a month to month spending plan, track costs of doing business, or sort and compose a lot of information calculations in spreadsheets of Excels.
ReplyDelete