Build me a SubRoutine in MS Access VBA.

Hello, I can create a program to perform data in MS access. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writing Microsoft Excel Macros. I can easily create macro to format and compare data in different excel sheets. I can easily create windows desktop app in .NET. Need to discuss in detail before starting. Thanks

Hi! I see the issue. What you need here is a custom import from Excel file (not TransferSpreadsheet) and this is easily done with some VBA coding. In one of the program I worked recently for a guy from Holland, we had around 20 different Excel format and all are imported into the same table. What I suggest is to create an import routine that will import data directly into your table, not to convert it to another format and then import from there. I do not see it as a good solution because a number of columns is dynamic. If you can explain to me how you import data into Access table and if you give me your backend, I could be able to suggest a better solution. Thanks! Regards, Branislav Mihaljev

Hi Sir/Mam, It is being my pleasure to introduce you to me. I am expert in advance excel. I have excellent knowledge of advance excel and I know many things in excel like Formulas (Countif, Sumif, Index match, Vlookup and offset etc.), Pivot, validation, macro, Pivot chats etc. Please review my profile. My profile is suitable for this project. I will complete this project on time. Please give me chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786

Hello sir, I am an expert in VBA and would like to work on this project with you. Thanks Aanvik

Hello. 30 % of employers hiring me once hired me again. I have 5 years experience in VBA. I CAN do this job, and do it well!