Hello, I'm a new member. (1 Viewer)

wmsalamanca

New member
Local time
Today, 02:43
Joined
May 27, 2014
Messages
11
I used MS Access to do a file comparisons. I import and export data very often, but presently I been running into issues because the files I'm importing are too large and the queries are taking too long. I will like to start using VBA to performs this task. My present objective is to be able to filer a file before importing. Example I have a million records and have an indicator with A and B to be able to identify the record. My objective is to be able to import the file but I will only will like to import the A records. I know I could do a query, but this is a daily. Can guide me on writing a VBA code for this task.
 

Jon

Access World Site Owner
Staff member
Local time
Today, 06:43
Joined
Sep 28, 1999
Messages
7,305
Welcome to the forums!

To help us better understand your needs, I would be very grateful if you could complete this 2 minute survey: Click here for the survey

All surveys are anonymous and not linked to your account.

I want to keep this the very best place for Access and your feedback helps us!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 23:43
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!
 

Users who are viewing this thread

Top Bottom