Excel based front end to query SQL database

In Progress

I require an Excel based front end that can be used to pull data from an SQL database.

User will enter a product lot code, this will then be used to get data from the SQL tables (e.g. what shop order the product was made under, what system transactions affected the lot number, what components were used to make the product etc. etc.

Some of the tables in the SQL database are large (circa 10 million records)

Skills: Excel, SQL, Visual Basic

See more: excel sql query, excel front end sql database, excel front end query database, excel database front end, database front end, front e, excel based, excel database visual basic, visual basic database excel database, 2013 excel visual basic, excel 2013 visual, excel order system, 2013 query, front product, excel database front, visual basic excel 2013, sql database front end, excel sql front end, excel 2013 visual basic, front end excel data, sql excel database, sql database front end visual basic, end end, database front end visual basic, user front

Project ID: #4632736

Awarded to:

FLinCanada

Perhaps I can help you. I have attached a few comments (or suggestions, depending on how you want to read them).

£150 GBP in 8 days
(15 Reviews)
3.6

42 freelancers are bidding on average £154 for this job

shuvrapintu

I have couple of concerns. please check PMB

£276 GBP in 7 days
(66 Reviews)
6.2
eperfections

EXPERT !!! Ready to start work. I have seen the attached doc. I would need the database structure to start with.

£150 GBP in 5 days
(87 Reviews)
6.1
mrbrave

Please chck message box for details of solution i will provide

£178 GBP in 5 days
(105 Reviews)
5.7
Krusche

We have worked quite a bit with Excel-SQL constellation. Please check the PMB.

£263 GBP in 3 days
(29 Reviews)
5.6
rinsadsl

please see my private message

£206 GBP in 7 days
(25 Reviews)
5.0
DenisSmolentsev

Hello! Let me propose you all the best of my experience with Excel Thank you!

£277 GBP in 7 days
(39 Reviews)
4.7
feninsoftech

Hi, This can be achieved by designing a C# Windows application with GridView. The application will have filter facility and based on filter criteria display data in grid. SQL Query will be written using Stored Proce More

£166 GBP in 20 days
(8 Reviews)
4.4
adim

Top 1% in VB6 on Freelancer and more than 15 years experience in SQL, Excel and VBA.

£150 GBP in 3 days
(13 Reviews)
4.3
srdas2012

Hi, We are expert in VBA & Sql. We can deliver the quality job. Please see our portfolio for our past and present work.

£74 GBP in 3 days
(13 Reviews)
4.2
jaylancer43

Hello - I have done similar projects. Please check your PM for details. Thanks.

£188 GBP in 5 days
(19 Reviews)
4.0
Pharoa

I will bring very strong Ms Excel and SQL Server application skills to bear on your project. I have over 19 years experience developing Excel, Ms Office and SQL Server applications.

£150 GBP in 5 days
(2 Reviews)
3.8
vikashgadia

we are excel macro expert....

£111 GBP in 2 days
(15 Reviews)
3.6
vickkey7

I am ready to start this project...

£189 GBP in 5 days
(10 Reviews)
3.4
rbbahia

Hi, I can do it for you

£88 GBP in 5 days
(7 Reviews)
3.2
murtaza1981

Hi, I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-fre More

£400 GBP in 7 days
(5 Reviews)
3.1
cosmoinfosys

Ready to start the work. Please check PMB for details. Thanks & Regards Kiran

£178 GBP in 4 days
(2 Reviews)
2.9
shagoon2u

Already worked on similar project earlier where integration between Excel and Database(MDB/SQL) is required.

£150 GBP in 3 days
(3 Reviews)
2.9
hardikshah83

Quite simple task, experienced programmer with more than 10 years of experience.

£100 GBP in 3 days
(4 Reviews)
2.7
ronijohn

IT Professional with 12 years experience, expert in VB, SQL and Excel

£145 GBP in 5 days
(7 Reviews)
2.7
sayli2

Can do it very easily.

£99 GBP in 15 days
(2 Reviews)
1.6