How to upload data from a spreadsheet to a Enterprise Managerdatabase
 

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.

How to upload data from a spreadsheet to a Enterprise Manager data
 

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.

How to upload data from a spreadsheet to a Enterprise Managerdatabase
 

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)?

How to upload data from a spreadsheet to a Enterprise Managerdatabase
 

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

Troll.