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

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 Post Reply

824

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...

Microsoft SQL Server

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...

Microsoft Access / VBA

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....

Microsoft Access / VBA

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, ...

Microsoft Access / VBA

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...

Visual Basic .NET

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...

Python

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=" +...

C# / C Sharp

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....

C# / C Sharp

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...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

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

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

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...

Microsoft Access / VBA

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

Similar topics