Sql query

Create an mySQL query on Cpanel which will import data from .txt files stored on the Cpanel ftp once a day. I have attached samples of the .txt files. There are multiple files on the ftp, they are labelled with todays date in reverse order i.e. YY-MM-DD. The file contains time stamps and a count. The query needs to import the file with todays date, and separate the time stamp and count. The query must be automatically triggered to occur once a day, at 12:30am.

Skills: Microsoft Access, Microsoft SQL Server, MySQL, PostgreSQL, SQL

See more: create account number query microsoft sql, programmer fixed pay, query sql server access 2007 vba, fixed pay job usa, additional fixed pay, php coder pay happy, pay pal aud oscommerce fix, access filter sql apply query, sample excel sqlrequest access db2 sql, converting access database sql server 2008, conversion access 2000 sql server 2005, convert access 2007 sql server 2005 express, convert access aspnet sql server, convert microsoft sql bak

About the Employer:
( 13 reviews ) Hawthorn, Australia

Project ID: #11730722

41 freelancers are bidding on average $191 for this job


Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I have checked "[login to view URL]" I can help you as PHP programmer to create script to run it everyday at 12:30 AM and import CSV files via FTP and More

$140 AUD in 1 day
(1060 Reviews)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

$147 AUD in 3 days
(76 Reviews)

Hello there, i'm expert on MySQL, actually i'm doing a job with load data from text file, we can use the command LOAD DATA LOCAL INFILE 'file_path' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '' More

$250 AUD in 3 days
(147 Reviews)

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & More

$155 AUD in 3 days
(15 Reviews)

Hello Sir, I have gone through your requirements regarding Sql query. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience in .NET,, vb.n More

$210 AUD in 10 days
(24 Reviews)

Hi, I had understood that you want to create a SQL query which will import the data in the cpanel ftp once a day. I had viewed your attached file and had also done work on the automatic time stamp and count. P More

$200 AUD in 3 days
(24 Reviews)

Hi! I can create shell script that can be scheduled in cron. This shell script will execute mysql command like this LOAD DATA INFILE '[login to view URL]' INTO TABLE ... with some additional options (path to file, mysql con More

$50 AUD in 2 days
(31 Reviews)

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to your requirements. I have lot of experience in SQL query and make backups in sever too. Price might be negotiable during discuss More

$135 AUD in 6 days
(24 Reviews)

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$55 AUD in 2 days
(29 Reviews)

Greetings! I have read your job and i can do this job with in time and with good quality. I have 5 years of experience in web development MySQL database and queries. I can do this job as you want . Please let me kn More

$130 AUD in 1 day
(13 Reviews)
$155 AUD in 0 days
(28 Reviews)

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Thank you, Best regards, David

$150 AUD in 5 days
(23 Reviews)

we can do this with a simple php script which import everyday automatically at a given time ....come on chat....thanks

$40 AUD in 1 day
(10 Reviews)

Hello My name is Pranav I have checked the details shared by you will do done exactly what you want Please consider my bid and we can discuss more so that i can assist you in better way our services always with More

$155 AUD in 7 days
(9 Reviews)

Hello, I have ranking in top 4000 on and I hope it will give you an idea about my work quality and dedication to work. You will be safe while working with me. I have dedicated in house team for Wo More

$555 AUD in 20 days
(1 Review)

hi sir, can you please provide us detail about your project ?? We will provide you best service than anyone else....

$388 AUD in 7 days
(17 Reviews)

Me and my team are working on the database projects.. have great experience in database. i can do this for you... this is to be done in 2 days.. contact me so that we can proceed further....

$111 AUD in 2 days
(6 Reviews)

Hi Dear hiring Manager, I am interested in the position of (SQL query) you recently posted. I have been a professional Developer for 4+ years, and i am very familiar with PSD to HTML,Wordpress,Twitter Bootstrap, CS More

$133 AUD in 1 day
(3 Reviews)

I have +5 year experience in SQL Query. To Provide Quality,modular and object oriented coding. Regards

$222 AUD in 3 days
(7 Reviews)

Hi There, Team WebXcellence here. How are you doing? We are one of the fastest growing company in Central India having more than 6 years of experience serving customers in US, Mexico, London, India, New Zealand, More

$568 AUD in 12 days
(6 Reviews)