How to update Access 2003 database through by Excel 2003

  • Thread starter Thread starter Jalal
  • Start date Start date
J

Jalal

Had imported Excel 2003 table to Access 2003. Need to update Access table
(Database) through by Excel automatically when ever the table is updated in
Excel.

Your concern is highly appreciated.
 
If you Link the Excel instead of Importing it will be updated as the Excel is
changed.
 
Karl,
Thank you for the contribution.
Had linked the table before importing it, had got errors like #Num! for a
lot of numbers (not all) and faild to modify the linked table properieties!
Any hints please?
 
had got errors like #Num! for a lot of numbers (not all)
This happens when Access interperts a text field as a number. Check the
records showing the error in the Excel file to see if they contain text like
546A1 or N/A.

To make sure that Access interperts a text field as text place alpha
characters in the first row after the field names. You can remove the added
row after linking.
 
Back
Top