Member Avatar for nsjayesh

I am working in an organisation. In this we want to create a database in MSAccess (MSoffice 2003) about the system information about the computers. By using one software we have the following inforamtion in text format. In this, We want to craete the first part as the field name. Can any one help me to solve this problem

System Name=PC20092
System Manufacturer=Hewlett-Packard
System Model=HP Compaq dc7700p Convertible Minitower
System Chassis=Mini tower
System Memory=999 MB
CPU Count=2
CPU Name=Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz
CPU Description=x86 Family 6 Model 15 Stepping 6
CPU Clock Speed=1861 MHz
CPU L2Cache Size=2048 KB
CPU Name=Intel(R) Core(TM)2 CPU 6300 @ 1.86GHz
CPU Description=x86 Family 6 Model 15 Stepping 6
CPU Clock Speed=1862 MHz
CPU L2Cache Size= KB
BIOS Description=Default System BIOS
BIOS Manufacturer=Hewlett-Packard
BIOS Release date=30.08.2006
BIOS SMBIOS version=786E1 v01.05
VIDEO Adapter Name=Intel(R) Q965/Q963 Express Chipset Family
VIDEO Description=Intel(R) Q965/Q963 Express Chipset Family
VIDEO Adapter RAM=256 MB
VIDEO Display driver=igxprd32.dll
VIDEO Driver version=6.14.10.4670
VIDEO Driver date=14.08.2006
NIC Name=Intel(R) 82566DM Gigabit Network Connection
NIC Description=Intel(R) 82566DM Gigabit Network Connection
NIC Driver version=9.4.21.0
NIC Driver date=19.07.2006
--
--
--

Regards
Jayesh

  • 2 Contributors
  • 1 Reply
  • 126 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by bhicks11
Member Avatar for bhicks11

There's more than one way to skin a cat but I might attack it like this (if I understand what you are trying to do correctly):

Open the text file in Excel - parse out the field to another column removing the = ...

Copy and paste special - transpose to another spreadsheet - Row 1. From Access import the resulting spreadsheet and check first row is header. Your field names will be the top row.

To parse out you would use something like: =LEFT(A1,FIND("=",A1)-1)

Copy the formula down all rows. Copy the entire worksheet and past special - Values.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.