Export data from Excel to access using VB script

[skancha]

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

[jsknight1969]

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.