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.
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.
