penn station posted:...My Excel workbook has an inventory tab and a purchases tab related by a purchase number field. I have report tabs based on pivot tables. I use auto-filter so I can sort or filter on any column...One thing I would like to have is images and have considered moving to a true database but that in itself is a big job.
If you know how to use pivot tables and auto-filters in Excel, you’re a very advanced Excel user. Most users don’t even know what a pivot table is, let alone how to use one. No wonder it has worked okay for you so far!
With a background in Oracle, you’ll figure it out. Any decent database program can import a csv file, and Excel can export csv data. You should be able to do an export/import routine and get your data into whatever database program you choose...or if you write your own.
