Running a excel macro from access

MaDoyle

Registered User.
Local time
Today, 00:49
Joined
May 2, 2008
Messages
11
I hope someone can help as i am in over my head a little,

the problem i am having is i have a txt file i am sent on a daily basis that has roughly 90,000 records in on a daily basis what i need to do is import this into a table. At the moment i have been manually running a mcro within excel that converts the data to CSV and splits thge data onto different tabs to show all the data, then copy and paste the data ionto the tbl. What i was wondering is how i would go about automating this, i have ok knowledge of access so hope someone can help
 

Users who are viewing this thread

Back
Top Bottom