Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JohnB
  • Order by date
  1. JohnB

    uploading, reading, inserting file into DB

    You can make the excel spreadsheet an ODBC and read it just like you can any table. You will have to give the spreadsheet a name(internally) and a name range, but once you do that the name becomes the table and it works very well.
  2. JohnB

    Date a table was LAST updated

    I put in a field called Updated and put a date/time stamp in the field. I then can run a MAX query on the Updated field and find out when the last record was updated which is the same as the last time the table is updated.<br>

Part and Inventory Search

Back
Top