10-09-2009, 08:46 PM
I need to export Excel data to access using Vb script. I need to export specific columns from the Excel sheet. Can someone provide me the code for the same.
Thanks
Sheela
Thanks
Sheela
Export data from Excel to access using VB script
|
10-09-2009, 08:46 PM
I need to export Excel data to access using Vb script. I need to export specific columns from the Excel sheet. Can someone provide me the code for the same.
Thanks Sheela
10-12-2009, 08:13 PM
Wouldn't it be easier to import from Access? It already has this functionality.
Code wise, that is a lot of code for someone to provide you with. Try 1. Open recordset to excel shee (internet should have examples) 2. Open Access DB connection (again internet examples) 3. Loop through Excel recordset and create SQL statement to insert into Access DB Again, I would think it would be easier to do with Access, but I can understand that sometimes you need a coded method. GL. |
« Next Oldest | Next Newest »
|
Possibly Related Threads… | |||||
Thread | Author | Replies | Views | Last Post | |
export UFT datasheet to excel and then append | Mozza | 0 | 1,915 |
09-04-2018, 08:58 AM Last Post: Mozza |
|
How to Access MS Excel Controls using QTP | gayuamlu | 0 | 2,197 |
06-13-2015, 02:06 AM Last Post: gayuamlu |
|
Search and import data from excel under some rules. | nwpulele | 2 | 2,969 |
02-19-2015, 04:10 AM Last Post: supputuri |
|
Excel and Driver Script | shipu | 1 | 3,861 |
02-27-2014, 09:09 AM Last Post: supputuri |
|
QTP Script for enter data to DB | geethu105 | 2 | 3,337 |
02-24-2014, 06:54 PM Last Post: guin.anirban |