Solved

from text to access to web

Posted on 1998-06-25
12
183 Views
Last Modified: 2010-05-03
i have started learning visual basic  a week ago but i am forced into a situation where i am expected to pull a well formatted text file in the form of a table where some columns could be accessed by the viewers who could make changes. these changes are updated in our database. the final product should be user friendly so they asked me to pull the data on to the web.
now what i plan to do is pull the text file into access using vb ado and make queries, forms etc. in access database and
later pull these forms using front page for editing and viewing.
i need some help from you in writing proper code in vb.
if there is some other suggestion. please reply. i would appreciate it.
chandra
0
Comment
Question by:chandrababu
  • 7
  • 4
12 Comments
 
LVL 7

Expert Comment

by:spiridonov
ID: 1464330
You do not need to wrtie VB code to import text file into Access, it can be easily done using access text import wizards
0
 

Author Comment

by:chandrababu
ID: 1464331
dear spiridonov,
i have tried the text import wizards and they are carrying so many errors, and sometimes it say that there are more than 65000 characters in a line and i have checked and seen that there are delimiters afetr each column and each line.
but if i were to successfully draw data using the TIW then do i think an update can be done on it every two hours and there are changes both in the access tables and the text file also.
hope i was clear enough about that.
i appreciate your response though.
thanks a lot
0
 

Accepted Solution

by:
Nniol earned 200 total points
ID: 1464332
Please reply to this answer so I can understand your problem correctly and help you some more.

You want to pull a large text file, which has editable content, and then display it on the internet?

My idea is to:
Write two separate VB programs. One will allow users to access the text, update and edit it.

The other is a VB CGI program that allows you to format the text for the WWW. Separately.

reply so I can help you further...
0
 

Author Comment

by:chandrababu
ID: 1464333
Dear Nniol,
the problem is basically this, i am supposed to pull a text file that is well formatted with delimiters and is in the form of a table. this is supposed to be put in a table form say an access table.once the table is made four to five columns of this 11 column table have  to be made avialable for some people to edit/add new data and this has to be updated. now since access is not all that user friendly for somebody who doesn't know access i am  supposed to put this access table, or forms or reports on the web such that they could access any of these and make thier changes and the table has to be updated so that somebody else using one of these five columns for editing knows that some changes have been made.
now i am able to pull the table(link) from the text to access but in some columns i am having  "#num" appearing in place of date and so i was wondering why.
now once i get to figure out the problem i should check how i could put the created forms and queries on to the web and update them. i however have frontpage.
if you have not understood my problem properly please let me know and if you have any code to get this work done please send me a copy because i'll need to complete this project even before i complete my access and VB course.
thanks a lot
chandra
0
 

Author Comment

by:chandrababu
ID: 1464334
Dear Nniol,
the problem is basically this, i am supposed to pull a text file that is well formatted with delimiters and is in the form of a table. this is supposed to be put in a table form say an access table.once the table is made four to five columns of this 11 column table have  to be made avialable for some people to edit/add new data and this has to be updated. now since access is not all that user friendly for somebody who doesn't know access i am  supposed to put this access table, or forms or reports on the web such that they could access any of these and make thier changes and the table has to be updated so that somebody else using one of these five columns for editing knows that some changes have been made.
now i am able to pull the table(link) from the text to access but in some columns i am having  "#num" appearing in place of date and so i was wondering why.
now once i get to figure out the problem i should check how i could put the created forms and queries on to the web and update them. i however have frontpage.
if you have not understood my problem properly please let me know and if you have any code to get this work done please send me a copy because i'll need to complete this project even before i complete my access and VB course.
thanks a lot
chandra
0
 

Expert Comment

by:Nniol
ID: 1464335
Chandra,

Are you sure you need to put it on the internet to be read and updated by the users? If you do and the course hasn't ataught you about CGI or ASPs then they are almost asking the impossible.

If you do not need web access, then write VB code, using the Data control, SQL, Recordsets and Databases. To create an administrastion program for managing and editing the data.

If you have to put it on the web, tell me, and I will try to help, but it would be better if I could speak to you properly. To hel pyou some more. If you need to know about CGI then look at:

http://hoohoo.ncsa.umich.edu

I think it contains info about CGI, how it works etc.

If you still want HELP!!!!

Then I will help you create CGI with VB.

Nniol
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:chandrababu
ID: 1464336
Dear Nniol,
why don't you send me your e-mail address or phone number so that i could talk to you directly.
infact i think i have been able to break the ice using access and linking tables and using some notes from http://www.audities.com/iisadmin/htmldocs/08_iis.htm
infact my friend is easily pulling access stuff on to the web using some .idc and .htx files and he was explaining things to me and i was just working on it right now.
but it was extremely nice on your part to show your willingness to help me.
i also apprecite the keepers of this Experts Exchange site and i have already told several of  my friends of its benefits.
now since we have made friends, i have a question.
i was planning on taking classes on Oracle, develepor 2000 because i am in oklahoma city right now and if i go back to school in stillwater i am not sure if i will be able to have enough time.
in fact i know i already am spending a lot of time on my project, access, VB etc. Infact my friend was insisting me to join this course and i was not sure what to do. so?
anyway please send me your e-mail address.
chandra
0
 

Author Comment

by:chandrababu
ID: 1464337
Dear Nniol,
why don't you send me your e-mail address or phone number so that i could talk to you directly.
infact i think i have been able to break the ice using access and linking tables and using some notes from http://www.audities.com/iisadmin/htmldocs/08_iis.htm
infact my friend is easily pulling access stuff on to the web using some .idc and .htx files and he was explaining things to me and i was just working on it right now.
but it was extremely nice on your part to show your willingness to help me.
i also apprecite the keepers of this Experts Exchange site and i have already told several of  my friends of its benefits.
now since we have made friends, i have a question.
i was planning on taking classes on Oracle, develepor 2000 because i am in oklahoma city right now and if i go back to school in stillwater i am not sure if i will be able to have enough time.
in fact i know i already am spending a lot of time on my project, access, VB etc. Infact my friend was insisting me to join this course and i was not sure what to do. so?
anyway please send me your e-mail address.
chandra
0
 

Author Comment

by:chandrababu
ID: 1464338
Dear Nniol,
why don't you send me your e-mail address or phone number so that i could talk to you directly.
infact i think i have been able to break the ice using access and linking tables and using some notes from http://www.audities.com/iisadmin/htmldocs/08_iis.htm
infact my friend is easily pulling access stuff on to the web using some .idc and .htx files and he was explaining things to me and i was just working on it right now.
but it was extremely nice on your part to show your willingness to help me.
i also apprecite the keepers of this Experts Exchange site and i have already told several of  my friends of its benefits.
now since we have made friends, i have a question.
i was planning on taking classes on Oracle, develepor 2000 because i am in oklahoma city right now and if i go back to school in stillwater i am not sure if i will be able to have enough time.
in fact i know i already am spending a lot of time on my project, access, VB etc. Infact my friend was insisting me to join this course and i was not sure what to do. so?
anyway please send me your e-mail address.
chandra
0
 

Expert Comment

by:Nniol
ID: 1464339
Chandra,

At the moment I have no email address and am using my friends
WWW account.

In fact I have just left university and have no email as such. So send yours to: John@forager.com with 'FAO: Ben Janes' in the subject.

I am in england so you can phone me if you want, but I am not going to put the number across the internet.

Ben
0
 

Expert Comment

by:Nniol
ID: 1464340
Chandra,

Are you sending me your email or not?


Ben Janes.

Try sending to this on:

baj@doc.ic.ac.uk
0
 

Author Comment

by:chandrababu
ID: 1464341
i did send a mail and there is a postman error and i didn't know what to do.
by the way i shall try this e-mail too.
by the way my e-mail addresses are
cvasasali@hotmail.com
cvasasali@ocntg.oc.lucent.com
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now