Member Avatar for swanside

Hello.
I have a MYSQL database and I receive CSV files throughout the day.
At present I have to open up my database and import the CSV file.

Is there a exe file that can run so the CSV file can be imported as and when it arrives on the server pc?

for example, the CSV file will land in C:\CSV

Thanks
Paul.

  • 2 Contributors
  • 4 Replies
  • 108 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by swanside

Recommended Answers

All 4 Replies

Member Avatar for pty

I think you should look at the LOAD DATA INFILE docs and cron a script to import for you

Member Avatar for swanside

Thanks I will have a look at that.
Can you run CRON jobs on server 2003 or do you need some extra softwear to run it?
Thanks

Member Avatar for pty

Thanks I will have a look at that.
Can you run CRON jobs on server 2003 or do you need some extra softwear to run it?
Thanks

Sorry didn't realise your server was Windows. I'm not an expert on Windows but I'm sure you could use a scheduled task in cron's place.

Member Avatar for swanside

OK. Thanks again, I will have a look at that and see what I can do.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.