We help IT Professionals succeed at work.

Data Collection Application

helloraza asked
Medium Priority
Last Modified: 2012-05-12

I need to develop a software application, that will be used for following tasks

1- extracting required data from different DBMS (Oracle, SQL Server, MS Access and even from MS Excel)

2- make a data file (can be Excel file or Access file)

3-Record all Data from this data file into MS SQL server

which plateform can be used for this (I am good at VB6 and MS Access programming).

can any web technology like client side JAVA script, be used or any other suggestion?

I want to make this application flexiable enough to extract data from any operating system like windows Server, XP/XP professional or windows 7, and insert that data into SQL Server.

Please give some suggestions.


Watch Question

You can use VB6 or MS Access for your app.  Just need to connect to the data sources to pull your data out, process in VB / VBA, then dump into MS SQL.

Yea, basically any web technology capable of interacting with a database can do this as well.  Just set up the ODBC data sources.

Any OS?  In that case web would be a great approach.  ColdFusion, .asp, .php...whatever floats your boat.  The client simply accesses through a web interface, making you 100% OS independent.  Again, simply set up your data sources specific to the servers you are extracting from / writing to.

In addition to mds-cos's comments, it sounds like you are talking about doing something that a "framework" would be good for.  There are a number of frameworks in all kinds of languages.  Frameworks handle the differences of various underlying data sources using an abstraction layer so you can focus on your app instead of all the confection types and language constructs (to varying extents.)

You need to decide first what your long term goals are for the resulting software and how it will be used to determine if a web app or a desktop-based platform would be better.  Also consider whether this will be used just by you or by other people and where will it be installed - you will have dependencies that must be met for any installed app, whereas a server-side web-based app may be easier to deploy.

There are not any frameworks I'm aware of for vb6, but depending on how long you plan to use and maintain it, if you are starting a new project, you should probably consider starting in a more current environment.



thanks for your prompt reply.

If I go for Web Solution, and choose PHP, then is is possible to do this on client side, and I dont need to use web server as i cannot setup web server on each customer.

If it is possible in PHP, any details,sample or specification regarding this.



Yes, php can run on a local system.  I think the way to do this is with the command line: http://php.net/manual/en/install.windows.commandline.php.  You wil still have to have php and it's dependencies installed to get php to run.

And there are multiple php frameworks to help.  I'm not an expert with php, but here is a site with some comparisons of frameworks you can look at: http://www .phpframeworks.com/

Mds-cos may have more info than I on this.



While searching on internet, some guys are talking about Python , Perl and Ruby

I saw a Java script example on web, in which it is using function getAdoDb and with the help of that, we can select and insert data into ms access.

would Java script be a good choice? or even newer one like AJAX or JQuery

Here's my analysis of what we've discussed so far:

Yes, jQuery could be an option, or .NET, Ruby on Rails, web2py, cakePHP, etc.  It depends on your experience and what direction you want to go.  I'm sorry, but I shouldn't really make a specific recommendation because my experience is more broad across a number of areas and less deep in any given area, so I wouldn't be a good source to know details for your situation.  

Your criteria or needs should be the driving factors.  You mentioned wanting to run on a local system without a dedicated web server, which sounds like it's a key factor.  Many, if not all, of the frameworks have the ability to run solo on a workstation.  So look more at what your key needs are, what languages you have experience in, what you know about how interested you are in diverging from your comfort zone, and do a few searches.  You'll find pretty quickly where the community support is behind the few you narrow down to.  That should help you decide.

You identified in your question 3 key needs.  #1 and #3 are going to be fairly straightforward in most languages and frameworks.  I can say, however, that some of the cross over between open source and proprietary systems can get dicey.  For instance, PHP used to have a SQL Server module, but it was removed a few years ago (I think because of problems with licensing or the original source of the library.)  Last I looked, you have to jump through a few hoops to get native PHP to easily work with SQL server.

Your #2, writing to Excel or Access, is a little more on the proprietary end.  And the unnumbered need to extract from a number of Windows-based OS's kind of points in that direction, too.

Don't hold me to this, but if Excel, Access, SQL Server, and various Windows version are key elements, I would suggest considering the .NET route.  They have a series of Express versions of development environments that are free as a starting point and you can grow into the more advanced versions.  See here.

If you cannot set up an actual web server to run your app, I would personally recommend against giong the web app direction.  Yes you can do it, but that is just adding a layer of complexity that is not necessary.

Totally concur with kbirecki aobut looking at a framework as a way to abstract from specific hardware.

You could also look at developing in a standard coding language, then just compile your app for the appropriate platform.  All of the modern programming languages are going to support connectivity to an outside data source.

Good point from mds-cos about the extra effort to use a web-based solution, unless you thought you'd eventually go to a web server hosted solution.  Then the portability is a benefit.  

@mds-cos, do you know if the .NET offerings have some portability that would make the use of a desktop version easier to convert to a web solution later?  

No, I don't know about that.  Sorry.


Thanks Bro!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.