[Solved] Advice on which program to use for invoicing

[ChuckW]

I want to create an invoice system for sequential Work Orders that automatically lookup description and cost of items in a 184979 line calc spreadsheet. I current use vlookup to return the information correctly but think a database would be better suited for generation of reports, printed invoices and work orders. I have programmed some with dBase3 and more extensively with Approach. I have no real experience with SQL or Access/Base. I have viewed quite a few of the tutorials on YouTube but still thought it wise to ask someone with more database experience than I, which would be almost anyone .

Thanks in advance for any suggestions.

Best regards,
ChuckW

P.S. I am new here even though I have been using AOO Writer and Calc for a couple of years.

P.S.S. Thanks to both of you for the advice. Time to put the ole thinking cap back on.

[RusselB]

The learning curve for databases is steep (I'm still working at it after about 3 months), but for your situation I feel that it will be well worthwhile,
The YouTube tutorials, imo, aren't the best.
I started with the PDF that is located at http://www.openoffice.org/documentation ... thBase.pdf and while it says it's for version 3, nothing I tried from the tutorial hasn't worked in 4.x

One thing that I like about Base, is it's relative simplicity and compatibility with the other parts of OO.
You can, probably, use your spreadsheet for your data for the database, rather than having to enter it all again.

[TheGurkha]

You can export your data from the sheet to CSV and most databases will import CSV if you create the table to match.