excel to file .mdb

[PLB83]

Excel to file* mdb :-)

Hi,
if possible, i would like your support. For work requirements, I was commissioned an Excel macro with VBA. I have programming experiences, but I've never used VBA. What I should realize is this:


I have an "excel A file" with -> "B sheet" with -> "C column" make for example from 1000 lines.
Furthermore, I have a folder containing 100 .mdb files.


My goal is to copy 100 rows at the time of the excel "C column" and paste them into the single .mdb files in the folder -> "table D" -> "column E".


Thank you very much for the support in advance.

[Kenneth Hobs]

Welcome to the forum!

Look for posts about ADO. You will need to have update privileges. You should practice on test files for such a task.

From the ADO examples that use Update or Insert, you will see that a connection string is needed. https://www.connectionstrings.com/