Major Update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 18 Jan 2008 20:46 GMT

I have a spreadsheet with over 60K rows that I need to update with an
additional column of data. Unfortunately it would be too much work to repull
the data and get it formatted appropriately. I was planning to use vlookup
to complete the update but so far has been very time consuming. Does anyone
have a better option not requiring VBA?

Reply to this Message

John W. Vinson - 18 Jan 2008 21:23 GMT

>I have a spreadsheet with over 60K rows that I need to update with an
>additional column of data. Unfortunately it would be too much work to repull
>the data and get it formatted appropriately. I was planning to use vlookup
>to complete the update but so far has been very time consuming. Does anyone
>have a better option not requiring VBA?

Is this a spreadsheet in Excel? or a table in Access? If it's in Excel, please
repost your question in an Excel newsgroup. If in Access, please post some
more details - VLookUp is an Excel function not available in Access, for
example.

John W. Vinson [MVP]

Reply to this Message

Jerry Whittle - 18 Jan 2008 21:32 GMT

Option 1. Import the spreadsheet into Acess as it would be much better in a
database with that many rows.

Option 2. Failling that, ask this question in an Excel forum!

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have a spreadsheet with over 60K rows that I need to update with an
> additional column of data. Unfortunately it would be too much work to repull
> the data and get it formatted appropriately. I was planning to use vlookup
> to complete the update but so far has been very time consuming. Does anyone
> have a better option not requiring VBA?

Reply to this Message

angel - 21 Jan 2008 06:38 GMT

"Richard" <Richard@discussions.microsoft.com> escribió en el mensaje de
noticias:C27C27B2-9832-4C59-8C53-C2756AA61D04@microsoft.com...

> I have a spreadsheet with over 60K rows that I need to update with an
> additional column of data. Unfortunately it would be too much work to
[quoted text clipped - 4 lines]
> anyone
> have a better option not requiring VBA?

Reply to this Message