Update SQL Server table from Excel and then populating remaining column data

Question

SQLPLUS not available

I need to be able to call a SQL script from the command line and pass in parameters for use. The script will read in data from an excel spreadsheet (file specified also at command line) to append records to an existing table in the database.

There are two additional columns in the database table that do NOT exist in the spreadsheet. Those columns are month and year. Those two values need to be entered at the command line and populated for each new record added. Whatever is entered at the command line will be the same value for each of the new records. (Any existing records in the table need to be remain untouched).

Can you help?

I was thinking about using osql to specify the user, password, database and .sql file.

Hi SbF, please post some code showing how you've attempted to tackle the problem, as this helps others help you. — Riv, Nov 29 '16 at 20:35
As of SQL Server **2005**, `isql` and `osql` are **deprecated** and should not be used anymore. Use `sqlcmd` instead — marc_s, Nov 29 '16 at 21:35

score 0 · Answer 1 · answered Nov 29 '16 at 22:12

0

I do and would use powershell as described by Not sure about formating link but paste into browser.

https://www.simple-talk.com/sql/database-administration/getting-data-between-excel-and-sql-server-using-odbc/

answered Nov 29 '16 at 22:12

Andrew

69
2
8

Update SQL Server table from Excel and then populating remaining column data

1 Answers1