How to upload data from a spreadsheet to a Enterprise Managerdatabase

C

confused

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.
 
J

Joel

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

docksi

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

gimme_this_gimme_that

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

Troll.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top