Excel worksheet to MDB

[lloughridge]

From excel VBA, I am looking for quick easy way to create a new MDB file and export all columns and all rows in the active worksheet to a new table in the new MDB file?

Any help, please?

[LokeshKumar]

Hey
Just FYI......MDB is MS Access file extension so it can not be created by Excel....

[romperstomper]

Hey
Just FYI......MDB is MS Access file extension so it can not be created by Excel....

With respect, that's just not true. You can use ADOX with Excel vba to create a database.

[LokeshKumar]

With respect, that's just not true. You can use ADOX with Excel vba to create a database.

So nice of you, I am good with excel formulas and VBA but not sure about this......
Could you please provide me a link.....it would be much appreciated and helpful for me......

[romperstomper]

I don't have a link and I can't post sample code as I can only access the forum on my tablet, but I'm sure you could Bingle it...