I use an excel spreadsheet to run a financial anaysis of selected orders. If the result is positive, I "take" the order. I use this sheet dozens of times a day and save each one as its own file. Is there a way to export the results of the analysis into an Access database. My vision of this system is using the spreadsheet to run the analysis and just hitting a "submit" type button that shoots the results over to Access. I think the key will be getting this to create a new record, with all of the data in the proper field.
Any help will be appreciated.
<!-- / message -->
Any help will be appreciated.
<!-- / message -->