Can someone please tell me how to upload data from a spreadsheet to a
database.
I have a spreadsheet with payroll data (employee id, name and work
hours and work type (reg, sick,etc..))

I don't have any knowledge of vba.

Is the database Access? If so, then import from Access and you probably don't
need a macro.

"confused" wrote:

Can someone please tell me how to upload data from a spreadsheet to a
database.
I have a spreadsheet with payroll data (employee id, name and work
hours and work type (reg, sick,etc..))

I don't have any knowledge of vba.

On Mar 6, 6:22*pm, confused wrote:
Can someone please tell me how to upload data from a spreadsheet to a
database.
I have a spreadsheet with payroll data (employee id, name and work
hours and work type (reg, sick,etc..))

I don't have any knowledge of vba.

I think we need some more info:
Is it a sql DB? You can use DTS or SSIS.
Do you want to do it programitically from VBA (connect to db, create
recordset and update the db)?

If you don't know anything about VBA, how is a VBA solution going to
help you?

Troll.