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!

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

Recent content by JT3

  1. JT3

    Importing Excel Data by Using TransferSpreadsheet

    Thanks. The brackets did the trick...!!!!
  2. JT3

    Importing Excel Data by Using TransferSpreadsheet

    Thanks for the assistance. I'm having some difficulty with one statement though. I'm getting an incomplete query clause runtime error. Do you see anything missing from: DoCmd.RunSQL "Delete * FROM 'TEMP_" & tableName & "' WHERE 'FMIB Number' = 0,"
  3. JT3

    Importing Excel Data by Using TransferSpreadsheet

    I am trying to import Excel data into Access tables. I have set up a macro to pull the data into the appropriate tables; however, we don't want to have empty records. There are occasions where the user won't be filling in all fields. Someone suggested creating temporary tables and running a...

Part and Inventory Search

Back
Top