Importing from Excel to an existing table / updating a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to access so don't know what is possible or where to look.
I need to create a spreadsheet to imput the data into and then have it
import it into an existing access database. How do I go about this?
Is it possible to import a spread sheet and only update cells that have
changed for a record?
 
It is much harder to update from an Excel spreadsheet after the initial
loading. Once the data is in the Access table, you should update directly in
the table via a form. In fact, you should just enter the data into an Access
table via a form and skip Excel all together.

However, if you will only be adding new records and not updating individual
fields, then you can filter your spreadsheet to only append new records.

From your question you will be updating individual fields; this will be
extremely harder as you will have to write code to implement your updating.

If you elect to stay with Excel, then you must make sure each column
contains the same data type, such as All Text or All Numeric. You can not
mix the field data types. Also your first row should be your field names for
the Access table. Although the field name row is not required, it does make
it helpful when enter data.

Access does have an excellent help reqarding the importing of Excel data.
 
Back
Top