Search results

  1. Air_Cooled_Nut

    Can I do an EXCEPT or DIFFERENCE clause in Access?

    Can MS Access perform the EXCEPT or DIFFERENCE clause? If so, what is the Access version of the syntax? TIA!
  2. Air_Cooled_Nut

    Must I have ODBC table Linked for VBA code to work?

    I have a small VBA module that pulls data from an ODBC data source and appends the data to a local Access table (from this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=607605#post607605 ). It works as long as I have a Linked Table from the ODBC data source. If I remove...
  3. Air_Cooled_Nut

    How to put ODBC data into a table?

    First, I'm very handy with VBA for Excel but basically a beginner when it comes to VBA for Access. I have established an ADODB connection and can pull data with VBA in Access 2003 (XP OS). I have the following code: ... Set objRecordSet = objCommand.Execute 'Pull the record set 'Test Do...
  4. Air_Cooled_Nut

    Changing "Import Specification" order

    I have an import specification and it works fine. It is used for a .csv file. My end user has changed their output of the .csv file. The fields are the same, however, the order has changed. Naturally, this causes a stink with the designated Import Specification. Is there an easy way to...
Back
Top Bottom