473,396 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

VBA script to pull data from HTML file into an '07 Ms Access database

I have very little knowledge or experience with VBA. I have an HTML file that is not in columns. It is a report that lists every time a vehicle comes in for repairs.

VIN 5578

Date 7-8-99

Part No. Duration. Code
8657 77 09H
1937 2 18S
9192 123 87J


The report repeats for each occurrence. Could someone help me with the script? I am assuming the script would have to look for the "header" and then a certain number if spaces over to find the data. The number of rows under part number will vary with each occurrence since the number of parts will vary. Some may not need any at all. I know a loop will have to be generated until it gets to the end of the report (file). It would be pulling the data into an '07 Ms Access database.

I could really use some help with the script and getting it to import into a table. The field names can be the same as the "header" names in the report. Table would be RepairLog

Thank you very much for your time and assistance.
Aug 9 '11 #1
0 1231

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: david | last post by:
Hello. I used to have a frames-based main page where the left side was the nav bar and the right side was split into top and bottom. The top portion was the welcome page and the bottom portion...
5
by: Norman Fritag | last post by:
Hi there, The Problem: I can't write data to an access database in a webfolder of a windows Prof 2000 machine, whereas the same web application runs fine under Windows XP. I looked into the...
1
by: Puhonien | last post by:
I have saved HTML files in the database (stored as image/binary datatype). I need to pull them back and open into a new browser. What's the best way to do this?
0
by: choknut | last post by:
guys i am a newbie in vb.net programming and want to seek help regarding my current program..i have an existing access database and want to use vb.net as to generate a report.question is how can i...
1
by: 1064871 | last post by:
Hi How to insert Data in Microsoft Access database using VB.net regards adil
2
by: rajaaryan44 | last post by:
how can we transfer data from one access database to another databse . the table name is same for both the database . in one table some records are there (rs say e.g.) now another table has say rs+10...
2
by: mousewonders | last post by:
Hi Guys, I am very new to VB. I am working on a project for class that will let people sign in to a fitness center and sign out. I have no clue what I am doing. I have searched and read and...
3
by: pranjal19870311codemaster | last post by:
hi i just want toconnect a html form to a access database . so that i can enter the data online. plz give responce soon. it will be much better if u help me with codes also. thanx
3
by: mkhizess | last post by:
Hi Buddzy Can you plz help to connect to Access DataBase input from HTML form using insert statement. I am still new on programming with html here is my code . <html> <head> ...
5
by: giandeo | last post by:
Hello Experts. Could you find a solution for this problem please! I have the following tables in Access Database Table Name: origin Fields Names: country, countrycode Table Name: make...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.