Page 1 of 4 1234 LastLast
Results 1 to 15 of 51
  1. #1
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25

    Trying to automate access

    To The Experts,
    I had a computer "whiz" modify a client side webpage I got from the Federal Communications Commission website:
    It's publicly available at - fcc.gov/media/radio/fm-and-tv-propagation-curves
    It runs on my Access 2000 (and old Windows 7 machine) and when given a text file it returns another related file in a text format.
    While it's awkward and slow to use - it works.
    Is there a way to further modify the FCC client side file or maybe program Access to automatically process a list of text files as in the following sample ?
    Currently I format the data into 2 columns first column shows the degrees radiating from a central point and the
    second column has the related Height Above Average Terrain number followed by "m" which stands for meters.
    I can only do one file at a time which leads to hours of screen time when it could be automated. I could make a much larger text file and separate stations by a comma or whatever.
    Any suggestions would be GREATLY appreciated. Thanks


    Station "KABC"
    0° 13.7 m 120° 89.8 m 240° 80.5 m
    1° 14.3 m 121° 90.5 m 241° 80.0 m
    2° 15.2 m 122° 91.2 m 242° 79.5 m
    3° 16.1 m 123° 92.0 m 243° 79.2 m
    4° 16.9 m 124° 92.7 m 244° 79.2 m
    5° 17.1 m 125° 93.2 m 245° 79.2 m
    6° 17.7 m 126° 93.6 m 246° 79.4 m
    7° 18.5 m 127° 93.9 m 247° 79.5 m
    8° 19.2 m 128° 94.3 m 248° 79.5 m
    9° 19.7 m 129° 94.7 m 249° 79.6 m
    10° 20.0 m 130° 95.2 m 250° 79.5 m
    11° 20.4 m 131° 95.9 m 251° 79.3 m
    12° 21.0 m 132° 96.6 m 252° 79.0 m
    13° 21.8 m 133° 97.5 m 253° 78.5 m
    14° 22.7 m 134° 98.4 m 254° 78.2 m
    15° 23.6 m 135° 99.2 m 255° 77.8 m
    16° 24.4 m 136° 99.8 m 256° 77.3 m
    17° 25.3 m 137° 99.9 m 257° 76.6 m
    18° 26.1 m 138° 99.8 m 258° 76.0 m
    19° 26.7 m 139° 99.7 m 259° 75.3 m
    20° 27.3 m 140° 99.6 m 260° 74.7 m
    21° 28.3 m 141° 99.4 m 261° 74.2 m
    22° 29.3 m 142° 99.2 m 262° 73.8 m
    23° 30.3 m 143° 98.6 m 263° 73.4 m
    24° 31.2 m 144° 97.2 m 264° 72.8 m
    25° 31.8 m 145° 95.5 m 265° 72.3 m
    26° 32.1 m 146° 93.8 m 266° 71.8 m
    27° 32.3 m 147° 92.6 m 267° 71.4 m
    28° 32.7 m 148° 91.9 m 268° 70.7 m
    29° 33.4 m 149° 91.3 m 269° 70.0 m
    30° 34.2 m 150° 90.4 m 270° 69.3 m
    31° 35.0 m 151° 89.2 m 271° 68.5 m
    32° 35.9 m 152° 88.1 m 272° 67.7 m
    33° 37.0 m 153° 87.4 m 273° 67.0 m
    34° 37.9 m 154° 86.7 m 274° 66.3 m
    35° 38.7 m 155° 86.0 m 275° 65.6 m
    36° 39.2 m 156° 84.9 m 276° 65.2 m
    37° 39.6 m 157° 83.4 m 277° 64.8 m
    38° 40.1 m 158° 81.7 m 278° 64.4 m
    39° 40.5 m 159° 80.3 m 279° 64.0 m
    40° 40.9 m 160° 79.6 m 280° 63.6 m
    41° 41.1 m 161° 79.2 m 281° 63.2 m
    42° 41.1 m 162° 79.2 m 282° 62.8 m
    43° 41.1 m 163° 79.2 m 283° 62.1 m
    44° 41.2 m 164° 78.9 m 284° 61.3 m
    45° 41.5 m 165° 78.5 m 285° 60.6 m
    46° 41.8 m 166° 78.5 m 286° 59.9 m
    47° 41.9 m 167° 78.9 m 287° 59.4 m
    48° 42.3 m 168° 79.6 m 288° 59.0 m
    49° 43.0 m 169° 80.3 m 289° 58.6 m
    50° 43.9 m 170° 80.9 m 290° 58.0 m
    51° 44.8 m 171° 80.9 m 291° 57.4 m
    52° 45.2 m 172° 80.1 m 292° 56.7 m
    53° 45.5 m 173° 79.0 m 293° 55.8 m
    54° 45.7 m 174° 77.6 m 294° 54.9 m
    55° 45.7 m 175° 76.2 m 295° 54.2 m
    56° 45.7 m 176° 75.0 m 296° 53.4 m
    57° 45.9 m 177° 74.4 m 297° 52.6 m
    58° 46.3 m 178° 73.8 m 298° 51.4 m
    59° 46.3 m 179° 73.3 m 299° 50.3 m
    60° 46.3 m 180° 73.8 m 300° 49.0 m
    61° 46.6 m 181° 74.2 m 301° 48.1 m
    62° 47.4 m 182° 74.3 m 302° 47.4 m
    63° 48.5 m 183° 73.5 m 303° 46.7 m
    64° 49.5 m 184° 72.8 m 304° 45.9 m
    65° 50.2 m 185° 72.2 m 305° 45.2 m
    66° 50.7 m 186° 71.3 m 306° 45.0 m
    67° 50.8 m 187° 70.0 m 307° 45.2 m
    68° 50.7 m 188° 68.5 m 308° 44.9 m
    69° 50.4 m 189° 67.2 m 309° 44.3 m
    70° 50.3 m 190° 66.0 m 310° 43.2 m
    71° 50.4 m 191° 65.4 m 311° 42.2 m
    72° 50.8 m 192° 65.1 m 312° 41.3 m
    73° 51.3 m 193° 65.3 m 313° 40.9 m
    74° 51.8 m 194° 65.9 m 314° 40.5 m
    75° 52.4 m 195° 66.4 m 315° 40.1 m
    76° 53.0 m 196° 67.1 m 316° 39.3 m
    77° 53.8 m 197° 67.9 m 317° 38.3 m
    78° 54.8 m 198° 68.8 m 318° 37.3 m
    79° 55.9 m 199° 69.7 m 319° 36.0 m
    80° 57.1 m 200° 70.4 m 320° 34.7 m
    81° 58.5 m 201° 71.1 m 321° 33.5 m
    82° 59.7 m 202° 71.6 m 322° 32.4 m
    83° 60.9 m 203° 71.7 m 323° 31.1 m
    84° 62.0 m 204° 71.6 m 324° 29.6 m
    85° 63.0 m 205° 71.6 m 325° 28.2 m
    86° 64.3 m 206° 72.0 m 326° 26.8 m
    87° 65.6 m 207° 72.4 m 327° 25.9 m
    88° 66.8 m 208° 72.2 m 328° 25.4 m
    89° 67.9 m 209° 71.6 m 329° 24.9 m
    90° 69.1 m 210° 70.7 m 330° 24.4 m
    91° 70.3 m 211° 70.2 m 331° 23.8 m
    92° 71.5 m 212° 70.2 m 332° 23.1 m
    93° 72.4 m 213° 70.7 m 333° 21.9 m
    94° 73.0 m 214° 71.6 m 334° 20.4 m
    95° 73.6 m 215° 72.9 m 335° 18.9 m
    96° 74.4 m 216° 74.5 m 336° 17.2 m
    97° 75.4 m 217° 76.0 m 337° 15.5 m
    98° 76.2 m 218° 77.4 m 338° 14.0 m
    99° 76.8 m 219° 78.6 m 339° 12.9 m


    100° 77.3 m 220° 79.8 m 340° 12.3 m
    101° 77.9 m 221° 81.1 m 341° 11.8 m
    102° 78.8 m 222° 82.4 m 342° 11.5 m
    103° 79.6 m 223° 83.6 m 343° 11.5 m
    104° 80.2 m 224° 84.4 m 344° 11.5 m
    105° 80.7 m 225° 84.9 m 345° 11.4 m
    106° 81.0 m 226° 84.9 m 346° 11.5 m
    107° 81.3 m 227° 84.6 m 347° 11.4 m
    108° 81.7 m 228° 83.9 m 348° 11.4 m
    109° 82.2 m 229° 82.9 m 349° 11.5 m
    110° 82.7 m 230° 81.9 m 350° 11.9 m
    111° 83.3 m 231° 81.0 m 351° 12.3 m
    112° 83.9 m 232° 80.4 m 352° 12.5 m
    113° 84.5 m 233° 80.0 m 353° 12.8 m
    114° 85.1 m 234° 79.9 m 354° 13.1 m
    115° 85.7 m 235° 80.2 m 355° 13.5 m
    116° 86.4 m 236° 80.7 m 356° 13.2 m
    117° 87.2 m 237° 81.0 m 357° 12.8 m
    118° 88.2 m 238° 81.1 m 358° 12.6 m
    119° 89.0 m 239° 80.8 m 359° 13.1 m,
    Station "KXYZ"
    0° 80.7 m 120° 79.4 m 240° 50.8 m
    1° 81.1 m 121° 79.5 m 241° 50.1 m
    2° 81.8 m 122° 79.9 m 242° 49.5 m
    3° 82.8 m 123° 80.5 m 243° 48.9 m
    etc. etc.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I expect could either further modify the 'client side' file or Access VBA. But we need code to analyze.

    How is page modified? Exactly what did the 'whiz' do? How do you 'give' it a text file?

    If you want to provide files for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25

    Input and output from access

    Thanks for your reply June 7. I'm attaching the zip file as it was given to me by the network guy. The INPUT data is a text file like this that goes up to 360 degrees :
    1 255.2 m
    2 250.7 m
    3 246.3 m
    4 244.8 m
    5 245.7 m
    6 249.8 m
    7 256.0 m
    ETC. up to
    360 231.2 m
    It is data from the FCC website (originally they display it in a table) showing terrain elevations looking outward from a point in one degree increments (the left hand column). The right hand column shows Average terrain for each of those degrees. The original FCC client side program would only calculate 1 degree at a time - VERY tedious and time consuming. Now at least it will return a two column Results file in seconds. Access returns a "Target" file that gives a distance in meters for each degree of the compass based on those terrain heights. Then I can calculate the envelope (a rough circle usually) of the FM station. Here's a sample of the Target output :
    1 12074 the second figure is distance traveled by the signal - in this case 12,074 meters or 12.074 kilometers to be exact.
    2 12086
    3 12100
    4 12120
    5 12136
    6 12156
    7 12173
    ETC.
    I am hoping this whole process can be automated further by giving Access a group of input files, each one labelled with the station call sign and then get a group of Output files also labeled with the call signs.
    Let me know what you think - hopefully I the input output part makes sense.
    Thanks again !! Towersignals
    Attached Files Attached Files

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I briefly looked at your attached database. Much of the "guts" of the calculations can be found in module1. The code seems to be void of any meaningful communication and comments and involves considerable use of arrays and functions. It seems to me ( the uninformed in the subject matter) that much of the preamble to get the data from the site into meaningful and useful format is missing. Without an overall description of the business and the procedures and the code involved, I think you will need someone familiar with FCC regs and the subject matter to be more helpful.
    Even if there was some "test data", it would be an effort to document the existing code for use by someone unfamiliar with details of the process(es).

    This quote from one of the routines has helped me with the advice/comments given above.
    '// Interpolation subroutine, this is a bi-variate surface fitting procedure, refer to the original FCC CURVES program
    '// and to the paper referenced in comments above for details. Sorry about the shortage of comments, but there were
    '// none in the original source.

    '// This has been modified from the original, taking into account the context in which it is being used. It was a full
    '// general-purpose routine, however many of the conditions that had exception-handling could never have occurred given
    '// the limited range of possible values in context. Much of that unnecessary code has been eliminated.
    '
    '// Arguments:
    '
    '// lx Number of columns in table.
    '// ly Number of rows in table.
    '// x Column enumeration values.
    '// y Row enumeration values.
    '// z Data table.
    '// n Number of points to lookup.
    '// u Column values for lookup points.
    '// v Row values for lookup points.
    '// w Return result of lookups


    As a guess I would think the original programmer was an engineer in the field and/or a Fortran programmer. I realize this statement is merely an observation/best guess on my part.

  5. #5
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25
    Orange,
    Thanks for your reply. Yes, the original program was was in Fortran (I have a copy) and the new Javascript client side version found on the FCC website here :
    https://www.fcc.gov/media/radio/fm-and-tv-propagation-curves is a modern update to it that typically works on a 1 INPUT = 1 OUTPUT basis.
    With the modified version and a little work on my part in setting up the input file, Access uses the zipped version and will do all 360 calculations and give me good results.
    All this works offline which is very handy for me. Maybe the problem needs the attention of a Javascript guru then ? I have no idea how Access interfaces with the input data.
    Towersignals

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Well, I'm not a javascript person, but if you give us more info on the input file, you may get more help.
    Even if you can outline the steps you use/do between signing on to the FCC site; javascript interaction; captured data....

    Your Access materials did not have any tables, but it did have populated arrays. So my thinking is that there was some interface to build the array from your input/extracted data. Again, I'm not familiar with the subject matter nor site etc, so it as more of a "first impression". I do have an interest in helping so any additional material would be useful.
    Good luck.

  7. #7
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25
    Thanks once again - I will set up a working input file and run it through Access with the FCC Curves.zip / .mdb file, get the output file and then post them all later this afternoon/evening.
    Towersignals

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I did notice several zip files available for download on the FCC site. I don't know how these files are related or if they are relevant to your process.
    Can you tell us how you get that input file? and generally the processing involved?

  9. #9
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25

    Origin of the access input files

    Hello once again,
    The FCC website is huge with many zip files but I mainly use the FM Query function to lookup a relevant station's data. Typically I will search for all stations a certain radial distance from a fixed point by referencing a latitude / longitude pair at the bottom of the main page.
    FYI the FM Query database also contains Canadian stations because of the treaty between the two countries that helps to eliminate cross border interference.This is the main FM Query search page: https://www.fcc.gov/media/radio/fm-query
    From that page I can get more specific data on specific stations like this: https://transition.fcc.gov/fcc-bin/f...t=0&facid=4296 If you follow the link on the right that says Calculate HAAT it generates the data table that is the basis for the INPUT file that Access uses. Right now I have to re-structure that table into 2 columns in a text file format to get the Access program to work.
    At this stage I can do one station at a time but my goal is to have Access process a group of 40 or 50 stations at once. More later on and thanks again. Towersignals

  10. #10
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by TOWERSIGNALS View Post
    Right now I have to re-structure that table into 2 columns in a text file format to get the Access program to work.
    You could have file picker code to select the input text file and select the folder to put the target file.
    I made a test text file from the data in Post #1 and created this code to change from 6 columns to 2 columns with the call sign at the beginning of each group of readings.
    Obviously, I named the button "cmdParse"
    Code:
    Private Sub cmdParse_Click()
        Dim strIN As String
        Dim strOut As String
        Dim ArrDeg(359) As String
        Dim sPart1 As String
        Dim sPart2 As String
        Dim sPart3 As String
        Dim sStation As String
        Dim RF As Integer
        Dim WF As Integer
        Dim i As Integer
        Dim Arr1 As Integer
        Dim Arr2 As Integer
        Dim Arr3 As Integer
        Dim Pos1 As Integer
        Dim Pos2 As Integer
        Dim Pos3 As Integer
        Dim OK2Print As Boolean
    
        'MUST have a source file AND a Target file.
        If Len(Trim(Me.txtSource & "")) = 0 Or Len(Trim(Me.txtTarget & "")) = 0 Then
            MsgBox "Missing Source or Target text files!!" & vbCrLf & "Please fix"
            Exit Sub
        End If
    
    '------------------------------------------------------------------------------------------'
    ' Should also check to ensure they are also TEXT files (.txt)
    '------------------------------------------------------------------------------------------'
    
    
        ' Open source file
        RF = FreeFile
        Open Me.txtSource For Input As #RF
        ' Open target file
        WF = FreeFile
        Open Me.txtTarget For Output As #WF
    
        'While not end of Source file
        Do While Not EOF(RF)
    
            'read line
            Line Input #RF, strIN
    
            ' Parse line
            If Left(strIN, 7) = "Station" Then
                'only print if read lines  after a call sign
                If OK2Print Then
                    Print #WF, sStation
                    'print the parsed values
                    For i = 0 To UBound(ArrDeg)
                        Print #WF, ArrDeg(i)
                    Next
                    ArrayFilled = False    ' set print flag
                    Erase ArrDeg    'clear affay
                End If
                sStation = strIN
            Else
                OK2Print = True
    
                'get the position of the "m"s
                Pos1 = InStr(strIN, "m") + 1
                Pos2 = InStr(Pos1, strIN, "m") + 1
                Pos3 = InStr(Pos2, strIN, "m")
    
                'get the string to print to file
                sPart1 = Trim(Left(strIN, Pos1))
                sPart2 = Trim(Mid(strIN, Pos1 + 1, Pos2 - Pos1))
                sPart3 = Trim(Mid(strIN, Pos2 + 1, Pos3 - Pos2))
    
                'get the degree order the reading should be at in the array
                Arr1 = Val(Left(sPart1, InStr(sPart1, Chr(176))))
                Arr2 = Val(Left(sPart2, InStr(sPart2, Chr(176))))
                Arr3 = Val(Left(sPart3, InStr(sPart3, Chr(176))))
    
                'replact the degree symbol and add to array
                ArrDeg(Arr1) = Trim(Replace(sPart1, Chr(176), ""))
                ArrDeg(Arr2) = Trim(Replace(sPart2, Chr(176), ""))
                ArrDeg(Arr3) = Trim(Replace(sPart3, Chr(176), ""))
            End If
        Loop
    
        ' at end of input file so print the last station and readings.
        If EOF(RF) Then
            If OK2Print Then
                Print #WF, sStation
                For i = 0 To UBound(ArrDeg)
                    If Len(ArrDeg(i)) > 0 Then
                        Print #WF, ArrDeg(i)
                    End If
                Next
            End If
        End If
    
        'closr the output and input files
        Close #2
        Close #1
    
        MsgBox ("Done")
    
    End Sub






    Quote Originally Posted by TOWERSIGNALS View Post
    At this stage I can do one station at a time but my goal is to have Access process a group of 40 or 50 stations at once. More later on and thanks again. Towersignals
    Not sure what you mean by this. Do you have multiple text files or multiple stations in one (each) text file?

  11. #11
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25
    Hello Steve and thanks for your reply,
    Here is a "sample" search I would do when locating an area for a new FM station or possibly to move an FM station.
    The starting page is : https://www.fcc.gov/media/radio/fm-query
    The attached HTML page shows the complete data list generated by the FM Query search engine when I asked for all data within a 100 kilometer radius of a latitude/longitude pair. I also save it as a text file so it will import into an Excel spreadsheet where I can delete some of the rows and columns of data that will not be used.
    Once I'm down to the list of licensed stations (LIC), applications (APP), and construction permits to build a station (CPs and others) I can go back to the HTML file and build a list of Calculate HAAT tables. Those become the INPUT files for Access to generate the bearing and distance columns for use in creating the stations "Contour". I attached a sample of a Contour Exhibit used in a project a couple of years back. It's all public information.
    It is a multi-step process and time consuming so wherever I can automate it with the speed of computers that leaves me more time for - fishing !!
    I am not sure what to do with the code you sent but automating the process of converting tables into 2 columns would save a LOT of time. Can it be added to the FCC Curves.zip routine that Access looks at or would it be better to use it separately somehow?
    Thanks once again for your help and from all those in the forum. Code and programming I don't know, but if anyone needs help in licensing and setting up a 2-way radio system (or Commercial AM/FM help) just let me know. John
    Attached Files Attached Files

  12. #12
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What is it that takes the Four Corners Area 100KM radius data and results in UsefulData?
    "where I can delete some of the rows and columns of data that will not be used."?? What criteria???

    Perhaps you could tell us a little more about the data and how it's used.
    Remember, we are not familiar with the subject matter nor how the data is used.
    Bottom line we don't know your business, so any info would be useful to help put a bigger picture together.

    You have LICensed stations, APPlications and CP construction permits which seems to indicate key components of your business.

    Good luck with your project. I certainly agree with making time for fishing.

  13. #13
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I had a little about antennas back in the dawn of time when I was in college, but I've slept many times since then (and my brain is like a sieve now) - don't remember anything about antennas now.

    I looked at the "USEFUL DATA.xls" file and managed to add a header so I could understand what the columns were. But, since I don't know/understand what you are doing, it doesn't make much sense right now.

    As I said, I copied the data in Post #1 and pasted it into a text file. Some if the characters might not be correct for some symbols (possible the degree symbol). I would have to have a "real" source text file for testing.
    But here is the code and the Source file for your testing.
    The process might/could be more automated, but I don't know the manual steps you take to get the final product, so can't give a definite answer.
    Attached Files Attached Files

  14. #14
    TOWERSIGNALS's Avatar
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    25

    Trying to automate access

    Thanks again,
    From the very bottom row of the FOUR CORNERS AREA SEARCH attachment ,I opened the data link to KRPT-FM (on the far left) then opened the Calculate HAAT link
    https://transition.fcc.gov/fcc-bin/haat_calculator?dlat=36&mlat=41&slat=45&ns=1&dlon= 108&mlon=13&slon=23&ew=-1&nradials=360&terdb=0&nad=27&inUSA=1&rcamsl=1802. &erp=6.&.html
    It returned the following table KPRT-FM Calculate HAAT DATA.zip (also in a text version) attached to this reply.
    I will try to get Access to use the file and see if it will re-structure the table into a 2 column format. Typically I have to go through a lengthy process.
    Evidently the modified FCC Curves.zip program could not handle the degree symbol ° after the bearing numbers 1°,2°, 3° etc. so I had to remove it in an Excel spreadsheet - one most tedious step that would be nice to eliminate....
    Attached Files Attached Files

  15. #15
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Using "KPRT-FM Calculate HAAT DATA.txt" as a representation of what the data text file format looks like, I modified the parse code. The code could be cleaned up a little more if the file will NOT ever have multiple stations (as in the example in Post #1).

    If you have 15 station text files, the code could be modified to parse ALL of the text files in a directory and write the modified files to a different directory. You could then write/modify code to execute the code for button "cmdBuild" for all of the modified station files.


    Maybe this will at least save you a little time....
    Attached Files Attached Files

Page 1 of 4 1234 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-20-2019, 10:42 AM
  2. automate importing access
    By mcchung52 in forum Access
    Replies: 1
    Last Post: 01-21-2012, 02:20 AM
  3. Automate report on ACCESS
    By Schoolo in forum Database Design
    Replies: 1
    Last Post: 12-18-2011, 02:11 AM
  4. Automate Access Queries
    By andreala in forum Queries
    Replies: 5
    Last Post: 08-23-2011, 06:01 PM
  5. How to automate a access query ... Help me
    By kusamharsha in forum Programming
    Replies: 0
    Last Post: 02-25-2009, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums