SQL import excel add current date column

Question

I would like to import an excel sheet to SQL using the import wizard and add an additional column to the table which has the current date.

For example:

In Excel, I have the following: Col1, Col2, Col3, Col4

In the SQL Table I would like: Col1, Col2, Col3, Col4 and an additional Col with the current date.

The table has all 5 columns with the 5th column a datetime datatype. I will delete the rows in the destination table before importing.

Please help.

Possible duplicate of How to insert date while importing Excel into SQL Server — Dan Bracuk
– Dan Bracuk, Commented Feb 22, 2018 at 18:01

Aaron Dietz · Accepted Answer · 2018-02-22 18:00:49Z

2

Add a default value of GETDATE() to your table:

ALTER TABLE [dbo].[yourTable] 
      ADD CONSTRAINT [DF_yourDate]  DEFAULT (GETDATE()) FOR [yourDate]

Then just exclude yourDate column from inserts.

answered Feb 22, 2018 at 18:00

Aaron Dietz

10.3k1 gold badge17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jan · Accepted Answer · 2018-02-22 22:04:44Z

2

When using Import Wizard you have the option of writing a query to specify the data transfer. This is adding the current datetime to a load from Sheet1.

    SELECT *,NOW() AS LoadDt FROM `Sheet1$`

LoadDt was placed first in data mapping, so in editing the SQL in that tab just moved that column to the end.

answered Feb 22, 2018 at 22:04

Jan

4215 silver badges15 bronze badges

1 Comment

Hannover Fist Over a year ago

Using NOW() instead of GETDATE()for Excel SQL is the main thing.

Collectives™ on Stack Overflow

SQL import excel add current date column

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related