Search results

  1. A

    Solved INSERT INTO works only on local table

    Thanks for sharing your experience!
  2. A

    Solved INSERT INTO works only on local table

    Hi DBguy! I tryed this and, on the same structure, on local works and on linked no. I managed to understand why the error occurs, there are fields in Excel which are recognized as number and my table field in access is Short Text type. I have put an TextToColumns in excel and I tranform all...
  3. A

    Solved INSERT INTO works only on local table

    Hi guys! I am facing a really weird problem. I am using this code: .RunSQL "INSERT INTO TBL_ALL_EMPL_DATA (" & tableFields & ") " & _ "SELECT " & inputReportFields & " " & _ "FROM [Excel 12.0 Xml;HDR=YES;DATABASE=" & inputReportPath & "].[WorksheetName$]" in order to import some...
  4. A

    Refer to another row in a table

    Hello all, My problem is as simple as I can't figure it out :) Basically, I have a table with 6 columns (Field1, Field2...) and a primary key called ID (1,2,3,....). In the first column (Field1) I want to retrieve the value from the 6th one (Field6) but from the above row. Something like...
Top Bottom