Export data from Excel to access using VB script - Printable Version +- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums) +-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP) +--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming) +--- Thread: Export data from Excel to access using VB script (/Thread-Export-data-from-Excel-to-access-using-VB-script) |
Export data from Excel to access using VB script - skancha - 10-09-2009 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 RE: Export data from Excel to access using VB script - jsknight1969 - 10-12-2009 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. |