How to copy many excel 2013 files to a table in access 2010 using vba RRS feed

  • General discussion

  • Hi,

    I need to compile many excel files to a table in access. I'm new programming in vba so, could you help me how to built it? I look up internet for a solution but is very hard to find, and most of them uses a excel file active.

    I need a code, that put 1 or 12 files (one file per month), if is January the code gets only 1, if its February, January and goes on until de 12th.

    they have the same data structure than the table of access database.

    excel file names 01jan.xlsx;02feb.xlsx,....,12dec.xlsx

    database name rec.accdbs table in database called consolidate

    thanks for your time.

    Wednesday, May 18, 2016 5:22 PM

All replies