473,405 Members | 2,334 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,405 software developers and data experts.

need help and advise with database

need help and advise with database...

i am an independant oil and gas consultant and have a fair amount of computer experience but, am lost when it comes to data bases .... i found a database online that contains names, addresses, phone numbers, fax numbers and email addresses (live links) of companies and people within the oil and gas industry ... i want to be able to utilize this db in excel so i can query and use excels "mail merge" system to send them emails.... the db online is in the .php format.

i want to show my appreciation by paying something for this service .... and i will.


i have queried the db online for all entries located within the united states and received over 70,000 entries .... i then copied and pasted them to microsoft word ... it is now 174 pages .. i have it saved to a file ... i can send the file to you.

again, my goal is to use this db in excel. ... please let me know if you might be interested in doing this and if you nedd any additional information.

thx,

jerry
Feb 14 '07 #1
2 1330
syedwna
11
what u mean to say
u have the usersinformation in word and want to transfer this into
excel or sql
i have not understood make it little bit clear
Feb 14 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
Jerry

When you received the records were they in comma separated format (i.e. were the Name, Address, contact, etc all separated with a comma. If they were then just copy the original text file and change the file extension to .csv instead of .txt. Then open the file from excel and save as an excel file.

Mary
Feb 16 '07 #3

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

Similar topics

0
by: Girish Agarwal | last post by:
--0-474210375-1058976151=:31789 Content-Type: text/plain; charset=us-ascii Content-Id: Content-Disposition: inline Note: forwarded message attached. __________________________________
0
by: serge calderara | last post by:
Dear all, I need to collect different type of data. Source of those data are CSV files and Access database. I am thinking on the way I should retrive those data under my VB.NET application in...
11
by: Jack | last post by:
I have a asp form where among others there are few text boxes and one check box. The checkbox is to indicate whether the entry is final. The checkbox is attahced to a field in table of type...
1
by: Celia Oblinger | last post by:
Please understand that I am not asking HOW to do something - but, rather, I just need some advise on what "technology" or method I should employ... The problem is this: I have a client for...
4
by: serge calderara | last post by:
Dear all, I need to build a web application which collects data from an SQL server database. SQL server database tables fields can be dynamically created or extended depending on my customer...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
12
by: nephish | last post by:
Hello there, i am getting to need to make my web stuff more OO. i have a project at work that we are porting to the internet, and i started learning php to do so. the project is now mamoth is...
1
by: | last post by:
Hi Database Gurus, Not to start a war among fanatics, but I just wanted to get honest opinion/advise of smart folks like you about this. We are about to begin development for a data intensive web...
0
by: db2admin | last post by:
Hi, I want to create web based directory of all the databases we have in our corporation ( @ 100 ) I want to have listing of databases categorized by project , business etc. If possible, I...
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: 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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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,...
0
jinu1996
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...
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
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...

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.