Search results

  1. J

    Need help on DoCmd.TransferSpreadsheet

    I'm working on a Sub to automate importing data from Excel to Access (table) and keeping getting an error msg: Run-time error 3170. Could not find installables ISAM. MS Access 2007, MS Office 12.0 Object Library is selected. Any help will be appreciated 'Import files to the new tables...
  2. J

    Is the possible to read Text file to a table

    I have a text file which has a header with several lines. Is there any to skip the lines, then read the rest of the file to a table? I have a sample file but don't know how to attached it. Thank you in advance
  3. J

    Create table in SQL view

    I'm using Access 2007. In SQL view, I'm not able to create tables. But I can do select query in SQL view. Do I need to set up something in order to create table in SQL view? Thanks a lot
  4. J

    Recordset

    I have several questions about recordset. 1. create a recordset field's name: With rstA.Fields .Append "fName", adChar 'got error. End With 2. After is is created, I will populate it by following, is it correct? With rstA .AddNew...
Top Bottom