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.

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

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

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.

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.