473,467 Members | 1,351 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

soft ware for allignment of data in Note pad and then copying pasting it in excel

2 New Member
--------------------------------------------------------------------------------

We have names and addresses data base of people across the world in note pad in vertical form as under.
name
Designation
company name
Address 1
Address 2
City
pin code
Country

I am looking for developing a software to make this data base into horizontal fomat and then copy /cut and paste into excel as per respective field by an automated process.Currently this is done by using key operations of cut and paste. however this is time consuming.
My questions are:
1) Is this possible to mak ethis process automatic? if so, which langyuage/technology? Can any one give hints where to start?

I am a layman in "software" however have engineers employed who can start doing with some tips and hints.

Is it possible under VB or any other languages?
Feb 6 '07 #1
1 1026
willakawill
1,646 Top Contributor
Yes this is quite an easy task in vb. Read the file in and output it as you like. The fastest and simplest would be to output it as a csv file which can be read into any database.
Feb 7 '07 #2

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

Similar topics

1
by: hzomorodi | last post by:
Hi, I am trying to find methods/tools that will help me automate the process of manually copying some data from one web page form and pasting them to another. We have to frequently fill out a...
1
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...
2
by: wisaac | last post by:
What I would like to do is automate the manual process of copying an image from an excel spreadsheet to the clipboard, and pasting it into an access table with an OLE Object field. I want to do...
4
by: phong.lee | last post by:
Here is an issue i've been trying to figure out which i do not have an answer to. Basically i have an excel spreadsheet which has data that i copy and paste from another resource. I also created...
1
by: com | last post by:
Extreme Web Reports 2005 - Soft30.com The wizard scans the specified MS Access database and records information such as report names, parameters and subqueries. ......
2
by: Ryan Riddell | last post by:
I wrote an application to pull data from certain ranges of an Excel workbook. The application works great for the first 2 of 4 sections I created. I created the third section of code and the...
1
by: Kc-Mass | last post by:
Brio and Toad are, as I understand them, front end query tools for server level data. An application I am working on requires that I move data from these tools to MS Access for reporting. The...
1
by: Paresh Shah | last post by:
We have names and addresses data base of people across the world in note pad in vertical form as under. name Designation company name Address 1 Address 2 City pin code Country
3
by: atif283 | last post by:
Hi I m worki on clip board m trying to copy RTF data(Text+Image) both txt and image on clip board its only pasting text On Excel not the image can any one help me in this regard I m using your...
8
by: Bruce_Stough | last post by:
I am currently using Control.DoDragDrop to drop a text string into Excel. I use the following code DataObject dd = new DataObject();...
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
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...
0
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...
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
tracyyun
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...
0
agi2029
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,...
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...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
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 ...

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.