I wish to create a database out of my excel spreadsheets. I have 2500/3000 excel spreadsheets all with similar data in the same place and I want to take this information into a database. All of the files are in the same directory and have the same naming convention.
Ultimatly I want to put this information into a program such as ACT! along with details from other areas such as linking in email addresses.