By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

Automate the import of a csv file

P: n/a
I have an application that updates a CSV file every 10 minutes. I am
trying to use Access to append the information in the csv file to a
table. The csv file does not append the new data, row 1 is just
replaced with the new data every ten minutes. My goal is to capture the
data in the csv file and keep a running log in Access.

I have created a macro I can execute to retrieve the csv data and
append it to a table, works great, now I would like to automate the
macro to run every 10 minutes. Any suggestions?

I might be trying to approach the solution wrong, but a macro was all I
could think of.

Thanks,
Scott

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sub Form_Load()
Me.TimerInterval = 1000*60*10 ' milliseconds*Sec_per_minute*10
End Sub

Sub Form_Timer()
' Retrieve the csv data and append it to a table
End Sub

(See TimerInterval in Help)

Of course, your app must be running with the form open. You should alos
include error_handling, and consider converting from using macros to VBA
code.

Another way might be to link the csv table, since Access can treat a linked
csv pretty much as if it was a table in another mdb.
Darryl Kerkeslager

"tjones8611" <un****@bellsouth.net> wrote:
I have an application that updates a CSV file every 10 minutes. I am
trying to use Access to append the information in the csv file to a
table. The csv file does not append the new data, row 1 is just
replaced with the new data every ten minutes. My goal is to capture the
data in the csv file and keep a running log in Access.

I have created a macro I can execute to retrieve the csv data and
append it to a table, works great, now I would like to automate the
macro to run every 10 minutes. Any suggestions?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.