How to upload data from a spreadsheet to a Enterprise Managerdatabase

  • Thread starter Thread starter confused
  • Start date Start date
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.
 
Is the database Access? If so, then import from Access and you probably don't
need a macro.
 
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.
 

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

Back
Top