CODEWITHSUNDEEP
sqlsql-serverexcel
Al2110
Al2110

Reputation: 576

Generating SQL INSERT from data in Excel file

I have a spreadsheet with thousands of records. Columns correspond to fields in a table in a SQL Server database. What is the quickest way to generate an SQL query to insert this data?

Upvotes: 0

Views: 12819

Answers (2)

Makwana Prahlad
Makwana Prahlad

Reputation: 969

@Al2110

based on your query, To generating SQL insert from data in excel file that show in below:

insert into customers values('" &B3 &"','" &C3& "','"&D3&"');

I hope above information will be useful for you.

Thank you.

Upvotes: 1

Syed
Syed

Reputation: 98

SQL Server Import and Export Wizard is a convenient option.

Upvotes: 1

Related Questions