VBA data import

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

Hi

We have an excel file from which data has to be imported to Ms Access table. Current logic taking time is little longer - reason we are checking cell by cell where the file is having 1.5 lakh rows.

want to simplify this load.

Contact me for further details on

9121303682

Data Processing Excel Microsoft Access Visual Basic Visual Basic for Apps

Project ID: #16003510

About the project

15 proposals Remote project Active 6 years ago

15 freelancers are bidding on average ₹1785 for this job

periyannas

Hi, I am a VB6, VBA expert. Let me take a look into your existing code, and see a way to optimize it. Thank you. Regards.

₹1500 INR in 2 days
(87 Reviews)
6.1
VBAautomation

If your are using Excel then it would be really slow. The good practice would first import the data into access table as it is into a temp table then validate using query or access vba functionality and update the fina More

₹1250 INR in 1 day
(23 Reviews)
5.1
Maheshpatel107

Hello, I am able to load data from access or csv to access table in seconds more than lacks of records. I Have 4 years experience of software development using VBA,Access,VB6.0,VB.net ect. Thanks Mahesh

₹1050 INR in 0 days
(12 Reviews)
3.2
zeehn4613

I have been using excel because of my degree that is management and science so its like a piece of cake.

₹1300 INR in 1 day
(0 Reviews)
0.0
debidev

you can hire me. i will deliver work on time.

₹1250 INR in 1 day
(0 Reviews)
0.0
ath59284b95ac211

I know what it takes to be an efficient employee for a busy and successful organization. In my past experience, as an Administrative Coordinator, I helped maintain very important aspects of many projects, handling mul More

₹1150 INR in 1 day
(0 Reviews)
0.0
hazemkabil

i have experience in VB for 3 years and i worked on the same issue before i can do it for you i just need to access your Access data and the excel file

₹1300 INR in 1 day
(0 Reviews)
0.0
Pinga

I can do that job, and I can do that job, and I can do that job, and I can do that job, and I can do that job!

₹850 INR in 1 day
(0 Reviews)
0.0
cbarreto07

Hello. Can I help you with your project? I have experience to help you develop it. count on me!

₹850 INR in 5 days
(0 Reviews)
0.0
himanshutongya

A proposal has not yet been provided

₹1050 INR in 1 day
(0 Reviews)
0.0