Importing from Excel

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

What I would like to set up is a way to use data from an
excel spreadsheet to create a database of records. The
excel spreadsheet changes each week and I want the Access
database to check the Excel spreadsheet and update the
database with only the new information and transfer data
from the unique (or new) rows of the Excel spreadsheet to
corresponding fields in the Access database.

From what I've read, it sounds like I might have to try
and use VB Script to make Access check each row of the
Excel spreadsheet and then append the Access table with
the new info. I just don't know VB enough to write
something from scratch.

Anything to point me in the right direction would be very
helpful. Thank you.
 
Hi Edward,

Have you considered just linking to the Excel spreadsheet from Access?


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| Content-Class: urn:content-classes:message
| From: "Edward" <[email protected]>
| Sender: "Edward" <[email protected]>
| Subject: Importing from Excel
| Date: Wed, 28 Jan 2004 12:25:34 -0800
| Lines: 16
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcPl3OIbELh1t/yzQfSti5WFd8iFVQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.externaldata
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.externaldata:48347
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.access.externaldata
|
| What I would like to set up is a way to use data from an
| excel spreadsheet to create a database of records. The
| excel spreadsheet changes each week and I want the Access
| database to check the Excel spreadsheet and update the
| database with only the new information and transfer data
| from the unique (or new) rows of the Excel spreadsheet to
| corresponding fields in the Access database.
|
| From what I've read, it sounds like I might have to try
| and use VB Script to make Access check each row of the
| Excel spreadsheet and then append the Access table with
| the new info. I just don't know VB enough to write
| something from scratch.
|
| Anything to point me in the right direction would be very
| helpful. Thank you.
|
 
Yes. The Excel spreadsheet contains file information and
it is distributed weekly by management (showing some new
files and removing some old ones). The Access db is to be
used to track how the file is worked so some things will
be added to the permanenet table in Access. I just wanted
it to sort through the Excel spreadsheet, locate the new
file numbers, and transfer the new file numbers and
related other cells into the Access db. Thank you for
your help.
 
Back
Top