Eric Barro
ebarro at verizon.net
Fri Apr 20 10:18:53 CDT 2007
And if you do it this way you need to do a Paste Special and then specify Text. Otherwise the data is all in one cell... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Richard Lavsa Sent: Friday, April 20, 2007 8:10 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] getting data out of an internet page Just to do it quick and dirty I've done the following.. I've had some luck doing this via the simple highlight what you want to copy, then Copy and then Paste directly into Excel. I've also had to depending on how it was formatted highlight, then copy and past into Word then convert the text into a table... Like I said.. Quick and dirty.. But it works most of the time.. Rich -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Friday, April 20, 2007 10:49 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] getting data out of an internet page My internet phone bill comes with a neatly laid out list of phone calls. AFAICT it is not a table however. I am wondering if there is a way to "extract" that data into a spreadsheet or table (other than building a programmed parser). John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com CONFIDENTIALITY NOTICE: The information contained in this transmission may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please be advised that any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you received this transmission in error, please contact the sender at TIGG Corporation immediately by replying to this email and deleting it from your computer. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 269.5.5/769 - Release Date: 4/19/2007 5:56 PM