Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chris - 25 Jun 2007 19:01 GMT
Any suggestions?

Some of these rows only need a few columns updated, and others need
all of them updated. If possible if say row 800 column 'S' is filled
in the access DB but is blank on the excel spreadsheet, if possible i
like to keep the existing data in access and over right it with a
blank cell.

The spreadsheet is a export of the access DB, changes were made/merged
from other spreadsheets so the Unique ID is the same and in column A.

A script suggestions to complete this?

Thanks :)
FSt1 - 25 Jun 2007 19:57 GMT
hi
no script needed.
declare your data a named range.
Hightlight your data. Insert>name>define>Name it>ok
Then go to access. link the named range to access as a table.
Then write an undate query to update the access table that the data came out
of.
this way you can download from table one, make changes in the excel table
then
update access with access from the excel table.

just a suggestion
regards
FSt1

> Any suggestions?
>
[quoted text clipped - 10 lines]
>
> Thanks :)

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.