build simple database and extract data via vb script or sql

Closed

I have a tool called email2db (see [url removed, login to view]) which will scan your inbox and extract data from email inquiries from customers. As we sell holiday rental villas, we then extract the 'arrival date' and 'departure date' from the email (html) and then generate a quote via email2db.

What I require is someone to write the following script and database (say MS Access) as follows;

calculate the TOTAL number of nights (be aware that the departure date is not counted as a nights stay)

then

design a database that will hold the nightly rate (365 dates a year)

read the database to sum the total value of the stay based on the number of nights

The database must allow for multiple homes to be added (using a unique number for each home)

I have attached a copy of the email that contains the dates that need to be extracted to then look at the database to determine the rental value that will be passed back to the email2db software. You also need to make yourself familiar with the email2db software which extracts the data from the email (you can download a free 30 day copy from their website)

If we can make this work, then this will grow into a really big project, but this is Phase 1, a proof of concept so need to work with someone that can put together a database quickly and write the scripts to determine the date range, read the database for nightly prices, sum, and return the value to email2db.

Skills: SQL, Visual Basic

See more: simple sql extract, script extract data database, write script extract data sql, work at homes, work at home database, simple scripts, simple html scripts, simple design tool, rental quote, rate visual basic, proof read from home, hold tool, free home design software download, free holiday website design, design access database, database for website software, database design tool, database design prices, calculate and write, access database design software, extract via, what is ms sql, ms access sql, website design software free download, sql software

Project ID: #1259412

Awarded to:

ABKrish

Hi I can do this project for you. I am a MCP certified professional and highly skilled in .NET, ASP.NET, C#, VB.NET Silverlight and SQL Server. Please see more details in PM

$300 USD in 4 days
(4 Reviews)
4.2

3 freelancers are bidding on average $283 for this job

rykseven

Dear Sir. I wanna work with you. I have a good software development team. Best regards.

$250 USD in 3 days
(0 Reviews)
0.0
yhermanto

Hi, I am expert with VB and SQL

$300 USD in 7 days
(0 Reviews)
0.0