Search results

  1. C

    Import .lis files as .txt

    Hi: I import several flat files from the network daily, all of these files have a .lis extension. Currently I open up a dos window and copy the files from .lis to .txt. I would like to rename these files through VBA, before importing them into Access. Is this possible? I tried looking into...
  2. C

    Create Table & Add Data

    Based on a prior post I created the following procedure, which creates a table (GREAT!!) but I can't get the data per the where statement to transfer over. I need all the fields populated (name, social, term, sumofamt) where I choose the term and the amount. I was trying to start by choosing...
  3. C

    import text file

    Hi: I am finally trying my hand at modules and VBA. I have converted some of my macros into modules and now would like to streamline some of the commands. One of the lines of the module imports a text file into a table. Dim FALL01 As String Dim SPRING02 As String FALL01 =...
  4. C

    import flat files

    I regularly import flatfiles from our network in order dissect, compare and produce reports. The report generator that produces these flat files only create files with a .lis extension. Access only seems to accept .txt extensions. Renaming the original flat file is doable but it does not...
    • catt
    • Thread
    • Replies: 1
    • Forum: Macros
  5. C

    VBA coding

    I love working with Access. I have migrated from Access2 to Access97 and now I work with Access2000. I have no problems with queries, forms, macros, but I would like to move to VBA. I have several books on VB, and the coding is fine, but not enough to help me with VBA. What I find very...
Back
Top Bottom