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 derfloh 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: DeannaF829
  • Content: Threads
  • Order by date
  1. DeannaF829

    Cannot access 'file.xls'

    I'm trying to update an excel spreadsheet with the following code: Private Sub ExportToFile(objRecord As Recordset, Optional Delimiter As String = ",") Const xlCSV = 6 Dim EXPORT_FILE_PATH1 As String Dim objExcel Dim objWorkbook Dim objWorksheet EXPORT_FILE_PATH1 = "C:\Daily_Data.csv" Set...
  2. DeannaF829

    Invalid bracketing of name but not a column heading or file name

    I've been looking in the forums, but not finding exactly what my problem is. I have an SQL Insert that is giving me the error [Microsoft][ODBC Excel Driver] Invalid bracketing of name '[8.28]'. Here is my query: strSQL = "Insert Into " & Chr(34) & "Verify_Not_Shipped$" & Chr(34) & " (" strSQL...

Part and Inventory Search

Back
Top