spreadsheet transfer from Excel to Access with VBA

I'm working on transferring spreadsheets from excel to Access. Each sheet from excel must correspond to each table in Access, and the sheet name in excel will be the table name in Access. I want to automate the process with VBA (either the code written within Access or Excel or both doesn't matter) . Automation is necessary since im dealing with multiple excel files, so I don't have to do import one table at a time, rather, just specify which file I need to transfer to or from, and click a button to get it done.

There are examples of VBA codes online on this matter, I have tried coding some of them myself but isn't exactly working. I have attached the excel file with the worksheets for example. The tables that would be generated in Access need to look the same as in the worksheet.

I would estimate $40 per hour of work, but no more than 4 hrs of work, so a lump sump of $160. Robust coding that is less prone to error, and with easy user interface is necessary and appreciated.



Aptitudini: Procesare date, Excel, Arhitectură software, Visual Basic, Visual Basic pentru aplicaţii

Vezi mai multe: access vba import excel append, vba code to insert data into access table from excel, access vba import specific excel sheet, access vba transferspreadsheet, import data from excel to access using vba in microsoft access, import excel into access, vba code to import data from excel to access table, access vba import excel into existing table, excel access vba developer, excel access vba programming dummies books book, convertir excel access vba, excel access vba training bangalore, printing excel access vba, multi user excel access vba, freelance excel access vba, import excel access vba, import data excel access vba, importing worksheet excel access vba, importing excel access vba, convert report excel access vba code

Despre angajator:
( 0 recenzii ) United States

ID Proiect: #17636056

Acordat lui:


Hello Pandu, This looks feasible. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 3 zile
(172 Recenzii)