Push data from Excel to Db2
I am very new to Db2 and also VBA to an extent. Could somebody help me out with below request.
I request somebody to help me with a sample code.... Say I have a table in db2...
Name and Employee Id
Now I have the details in Excel.... Say in sheet1.. Column A is Name and Column B is Emp ID
I require a code with which I can make a connection to my database and push the data to my tables in db2....(Probably with some explanation like code breakdown @ important palces)
Please help me开发者_运维技巧 with this request.. Thousand thanks in advance....
I have done this before without any code using a simple process:
- Create a new database in Microsoft Access.
- Import the Excel spreadsheet into a new table in the new Access database.
- Set up an ODBC datasource that points to the DB2 database you want to import into.
- Use the ODBC connection from Access to export the table into DB2.
精彩评论