davis
Fri Apr 30 23:58:29 CDT 2004
"Viatcheslav V. Vassiliev" <msnewsgroup@www-sharp.com> wrote in message news:<eQnE9hfLEHA.3712@TK2MSFTNGP10.phx.gbl>...
> You should determine first what language do you want to use - at first,
> which language you are familiar with. This is possible to do in most
> languages - if you will choose VBScript, then your user interface will be
> HTML page with .hta extension (HTML application).
>
> You should write what you have (i.e. Excel file with data - describe columns
> etc.), which language you know (VBScript, JScript, C++, C#, Delphi, Visual
> Basic, VB.Net). Is your another program written yet? If so, which language
> is used? Does it load data from database - what is that database?
>
> If you just want to convert Excel speadsheet into database table, it is easy
> but solution depends on what kind of database you are using - in Access, you
> just choose import in menu.
>
> //------------------------------------
> Regards,
> Vassiliev V. V.
>
http://www-sharp.com -
> Scripting/HTA/.Net Framework IDE
>
> "JDevine" <justin__devine@hotmail.com> ???????/???????? ? ????????
> ?????????: news:f9d01b73.0404290632.6f3951f@posting.google.com...
> > I am going to attempt to write a script that can pull data and enter
> > it into another program with drop down boxes, radios, fill ins etc.
> > My question is three part
> >
> > 1.IS THIS POSSIBLE?
> > 2.WHAT DO I NEED TO ACCOMPLISH THIS (in terms of source for the
> > database into which I want to post the data, as in object names of
> > boxes/radios etc)
> > 3. What is the best language to use to do this in. If it is not
> > VBscript.
> >
> > Basically I have been handed this huge Excel document and been asked
> > to enter it into a database by hand. I want to avoid this at all
> > costs as it will take weeks of work and the amputation of at least 2
> > fingers to accomplish. If anyone can help please shoot me any
> > comments that may help at all. Anything.
> >
> > My sincere thanks in advance to anyone who has any input on this
> > issue.
> >
> > Justin__devine@hotmail.com
If you just want to move the Excel data as tables into some other
database, our Super*SQL tool will do it for you. It will produce a
delimited ASCII file which can be immediately loaded into Oracle,
MySQL, Access, SQL Server, etc. It is written in Java. For more
information visit www.sqlmagic.com.