Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Data from Excel to Access

0

I have to import data from Excel to Access using Macros to automate the process.

I already have an Access table with data in it. The Excel sheet from which the data needs to be imported and has a lot of data but only selected fields are to be imported.

Also, I want to contrain it using the time coulumn, as the data must be imported after the shift ends at 7 pm.

excel
posted by: Namita17 on Wed May 5, 2021 at 10:27 am
Answer
Discuss

Discussion

Hi Namita and welocme to the Forum

Please edit your original question to add a representative Excel file (using the Add Files... button) so we can see the amount of data and what you mean by the "time column" etc.
John_Ru (rep: 6142) May 5, '21 at 11:59 am
This will have to be solved from the Access side, meaning you will need code that is run from Access. That makers your question only remotely related to Excel. This forum is unlikely to be able to give you the best answer.
Variatus (rep: 4889) May 5, '21 at 7:53 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login