I would greatly appreciate help in importing data from an Excel spreadsheet into an Access database. I am using Access97 on a Dell portable with W98SE.
I have an Excel spreadsheet (test1.xls) with 4 columns and 7 rows, populated with text in each cell.
I want to create an Access database...