how to read data in txt formate and put it into excel sheet

1 New Member

i have got a data in notepad in formate like
1AAMA04BC 2008 REAL ESTATE REPORT PAGE: 1
02/19/08

0412 AF221224-1002 FARMING/RANCH LAND-N 9010 10,710 0
2 1 3,213 0
3 ZIMMERMAN, BARRY 032215 W 91ST ST DESOTO KS 66018
4 1 ZIMMERMAN, DARREL E. TRUSTEE 007425 GARDNER RD DEC
4 2 ETAL
5 1 24-12-22 SW 1/4 NW 1/4 40 ACRES
5 2 DEC 220

0412 AF221225-1013 FARMING/RANCH LAND-N 9010 2,480 0
2 1 744 0
3 0POBOX 720 DESOTO KS 66018
4 1 PRUDDEN, STEVE A. 029230 W 83RD ST DEC
4 2 PRUDDEN, CHARLENE
5 1 25-12-22 SW1/4 NW1/4 LYG S OF RR & BG SE CR SW1/4 NW1/4 E
5 2 264' TO C/L CRK N 249.48' NW 462' W 47.52' S 660' TO POB
5 3 EX .16 AC EX .371 AC IN ST & EX 6.24 AC 10.919 ACS M/L
5 4 DEC 249

0412 AF221225-1017 SINGLE FAMILY RESIDE 1101 60,090 57,210
2 1 6,910 6,579
3 WALKER, DALE D. 0POBOX 268 DESOTO KS 66018
4 1 WALKER, DALE D. 028880 W 83RD ST DEC
4 2 WALKER, JANICE K.
5 1 25-12-22 BG 36.37' N 391.22' WCTR SEC W 100' NW 189.55' NW
5 2 65' NW 120' NW 98.12' NW 229.58' E 265' S 650.77' TO BG
5 3 2.7 ACS M/L
5 4 DEC 240

0412 AF221225-1022 FARMING/RANCH LAND-A 9020 1,230 4,220
2 1 369 1,055
3 0POBOX 860321 SHAWNEE KS 66286
4 1 STOUSE, GREG E. 029150 W 83RD ST DEC
4 2 STOUSE, LISA
5 1 25-12-22 BG 989' E SW CR NW1/4E 552.8' TO C/L CEDAR CRK NE
5 2 256.8' NW 158.3' NW 215.9' SW 65.8' SW CUR RT ALG S RTWY/L
5 3 RR 354' S 505' TO POB EX .16 AC IN ST 6.24 ACS M/L
5 4 DEC 249C

0412 AF221225-2009 SINGLE FAMILY RESIDE 1101 60,220 58,680
2 1 6,925 6,748
3 023400 W 82ND ST SHAWNEE KS 66227
4 1 PENNYS CONCRETE, INC. 029480 W 83RD ST DEC
5 1 25-12-22 2 1/2 A N NO 10 HIWAY W1/2 SW1/4 EX .25 ACS 2.25
5 2 ACS M/L
5 3 DEC 254

0412 AF221225-3005 SINGLE FAMILY RESIDE 1101 52,060 59,040
2 1 5,987 6,790
3 003411 LAZY BROOK LN LAWRENCE KS 66047
4 1 JOHNSON, ERNEST E. 028290 W 83RD ST DEC
4 2 ETAL
5 1 25-12-22 1.50 A N OF STATE RD 1.50 ACRES
5 2 DEC 230A

*************** *************** *************** *****
i will have to convert into excel sheet
like
Pro Code ProType Total Property Val Residential Property Val Assecced Value Improved Landval Mail Address Mail City Mail State Mail Zip Owner Last Name Owner First Name Owner Mid Name Property Address Legal Description1 Legal Description2 Legal Description3
AF221225-1013 FARMING/RANCH LAND-N 9010 2,480 0 744 0 0POBOX 720 DESOTO KS 66018 PRUDDEN STEVE A 029230 W 83RD ST 25-12-22 SW1/4 NW1/4 LYG S OF RR & BG SE CR SW1/4 NW1/4 E 264' TO C/L CRK N 249.48' NW 462' W 47.52' S 660' TO POB EX .16 AC EX .371 AC IN ST & EX 6.24 AC 10.919 ACS M/L

Mar 14 '08 #1

Subscribe Reply

829

Similar topics

8340

Combining data from differnet Excel sheets

by: Ilan | last post by:

Hi all I need to add data from two Excel sheets (both on the same workbook) to an existing table in my SQL DB. The problem is that each sheet holds different fields for the same record, though the records are sorted by row numbers. (I had to split the fields to different sheets because Excel has a limit of 256 fields in each sheet) My...

Microsoft SQL Server

17386

Export Data to Excel for Report Printing

by: Steven Stewart | last post by:

I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed a database for her which is intended to make things a lot easier; however, I don't have a lot of experience with Access and I find that designing...

Microsoft Access / VBA

25027

VBA code help Export Excel data to Access table

by: Mads Petersen | last post by:

I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown. eg. this only transferes the first record in the area. ..Fields("Uge").Value = ws.Range("A98").Value Sub SelectMaster()

Microsoft Access / VBA

11246

How to insert bulk data into an existing data base?

by: Hi5 | last post by:

Hi, I am new to access I usedto work in Oracle and Mysql. I am after a way that enables me to populate a database I designed in access with lots of data which can be sorted in excel sheets, The source of all data is a very large size (100*2000) excel spread sheet In which some data types are absulotely Irelevant to access data types in...

Microsoft Access / VBA

10427

How to insert data into Excel sheet from VB.NET

by: Mamatha | last post by:

Hi When i clicked a button, i want to insert data from listview in VB.NET to Excel sheet. If you know the solution either above or below is ok for me. I know how to insert from a textfile,but all data of textfile inserted into only into a single cell.I want to insert single line of text file for each cell. I tried to insert data into...

Visual Basic .NET

5826

pyExcelerator - Can I read and modify an existing Excel-WorkBook?

by: Marco Aschwanden | last post by:

Hi I would like to 1. import an existing Excel-sheet (a template) 2. and add some data to it 3. and save it under a different name afterwards. To me it seems, that pyExcelerator does not support the reading for modification of an Excel-sheet. It allows only the "parse_xls" but I would like to keep the "formatting" in the template.

Python

4804

how to read data from a sheet in excel file

by: tanilov | last post by:

Hi all, I need to read data from an excel file and populate a dataset. After some search I found following code: connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename.ToString() + ";Extended Properties=\"Excel 8.0;HDR=YES;\""; DataSet myDataSet = new DataSet();

C# / C Sharp

2548

Read Excel data in ASP.NET Error

by: Johnny | last post by:

Hi all: I am trying to write some code to read an Excel spreadsheet from an ASP.NET application. For some reason no fields that have a number in them are read, while text data is read just fine. I am using a connection string: Conn1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; Conn1 += @"C:\Temp\Success Partners\Test.xls";

C# / C Sharp

15898

Read / Modify (Update) data of an Excel Sheet using PHP script

by: tsanthoshk | last post by:

Hi All I am trying to read and modify input excel file. when i update the data in excel sheet already existing format is washing out. It mean if excel sheet contain colors those are not appearing once i update. Can any one suggest links or scripts for this problem. Requirement: input excel sheet will be given. Read the data and modify...

PHP

7464

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7805

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7413

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5968

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5323

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3440

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1874

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1012

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

700

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General