473,385 Members | 1,838 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,385 software developers and data experts.

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

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.
Feb 6 '07 #1
1 1355
bartonc
6,596 Expert 4TB
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.
I'd say that Excel macros may be a pretty good way for you to go. With macros you can record the keystokes that you use to perform the task and the play the macro (which is really a VB program) to achive automation.
But let's see what others might have to say on the Techie Talk Forum....
Feb 6 '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...
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();...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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: 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,...

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.