I am creating a database from addresses I am finding on the 'net. It is
going pretty slowly copying and pasting into an Excel spreadsheet. Most of
the addresses are in a block format:
Name
Address 1
Address 2
City Province Postal Code

Is there a faster way to do this or am I just kidding myself? Please help...

Hi,

Use Refresh Web Query - Server push technology.

Refresh a Web query

Click a cell in the region of the worksheet where your query data was
returned (also known as an external data range (external data range: A range
of data that is brought into a worksheet but that originates outside of
Excel, such as in a database or text file. In Excel, you can format the data
or use it in calculations as you would any other data.)).

Click Refresh Data on the External Data toolbar (toolbar: A bar with
buttons and options that you use to carry out commands. To display a toolbar,
click Customize on the Tools menu, and then click the Toolbars tab.).

A spinning refresh icon appears in the status bar (status bar: A horizontal
bar at the bottom of the screen that displays information about the current
condition of the program, such as the status of items in the window, the
progress of the current task, or information about the selected item.) to
indicate that the query is running. Double-click the icon to check the status
of the query.

Tips

You can have your data refresh automatically when the file is opened, at
timed intervals, or in the background by clicking Data Range Properties on
the External Data toolbar and selecting or clearing options under Refresh
control.

If the data returned to your worksheet after a refresh isn't what you
expected, check the Web page you are querying to make sure it is in the same
location and that the data on it is provided in the same way as when you
created the query.

Challa Prabhu

"mmcstech" wrote:

I am creating a database from addresses I am finding on the 'net. It is
going pretty slowly copying and pasting into an Excel spreadsheet. Most of
the addresses are in a block format:
Name
Address 1
Address 2
City Province Postal Code

Is there a faster way to do this or am I just kidding myself? Please help...

Hello,
That's not what I was looking for but thank you for your response. What I
want to know is is there anyway that I can copy and paste the names and
addresses into a Word document and then convert the Word document into an
Excel spreadsheet?
The info. i.e. name, address, province, and PC are separated by a comma.
I remember doing something like this about 10 years ago and I cannot
remember the steps. It had something to do with "delimiting by comma"?

"mmcstech" wrote:

I am creating a database from addresses I am finding on the 'net. It is
going pretty slowly copying and pasting into an Excel spreadsheet. Most of
the addresses are in a block format:
Name
Address 1
Address 2
City Province Postal Code

Is there a faster way to do this or am I just kidding myself? Please help...