Update Expire Date - Multiple Coupons

I have a several thousand coupons created and need every one of the expire dates to be extended.

Is there any way to go into the database and make the changes?
Or
Is there any way to export them all, make the changes and then import them?
Or
Other suggestions?

Changing them one at a time will take a long time.

Hello,

Updating the database is your best bet:
Table: #__awocoupon
column: expiration

The expiration format is in datetime, so for example "2013-07-01 14:32:52".

Thanks Seyi,

I also realized that I could run a report, save as .csv.
Then change the dates in the .csv.
Delete the specific coupons from the coupon area and then upload the changed .csv.

Is this also viable or would it create problems?

You cannot edit with an import, only add new.

So yes, you could do it, but you would first have to delete the coupon codes you are importing. You would loose customer history of the specific coupons by doing this.

Understood... Thanks