ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Data Export from Database

    Scheduled Pinned Locked Moved IT Discussion
    microsoftaccessexcelcsv
    17 Posts 5 Posters 4.7k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • gjacobseG
      gjacobse
      last edited by

      The final product is the wish to have multiple data sets that can be 'merged' into one CSV file to be programmed to the device.

      Data would consist of:

      • NOAA Radio Frequencies
      • GMRS/FRS Radio Frequencies
      • EMT/Fire
      • Marine / FAA
      • ARES - Amateur Radio Emergency Service Frequencies

      This is for a group of people who do some SAR (search and rescue), EMT support.

      scottalanmillerS 1 Reply Last reply Reply Quote 0
      • scottalanmillerS
        scottalanmiller @gjacobse
        last edited by

        @gjacobse said:

        The final product is the wish to have multiple data sets that can be 'merged' into one CSV file to be programmed to the device.

        Data would consist of:

        • NOAA Radio Frequencies
        • GMRS/FRS Radio Frequencies
        • EMT/Fire
        • Marine / FAA
        • ARES - Amateur Radio Emergency Service Frequencies

        This is for a group of people who do some SAR (search and rescue), EMT support.

        You'll need programming for that. That's not an export, that's a conversion between data types.

        gjacobseG 1 Reply Last reply Reply Quote 1
        • gjacobseG
          gjacobse @scottalanmiller
          last edited by

          @scottalanmiller said:

          You'll need programming for that. That's not an export, that's a conversion between data types.

          Would setting this up in Python perform better or just use Excel?

          scottalanmillerS 1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @gjacobse
            last edited by

            @gjacobse said:

            @scottalanmiller said:

            You'll need programming for that. That's not an export, that's a conversion between data types.

            Would setting this up in Python perform better or just use Excel?

            Probably depends on your skill set. As I am a moderate Python programmer and a worthless Excel user, for me Python is worlds easier.

            JaredBuschJ 1 Reply Last reply Reply Quote 0
            • JaredBuschJ
              JaredBusch @scottalanmiller
              last edited by

              @scottalanmiller said:

              Probably depends on your skill set. As I am a moderate Python programmer and a worthless Excel user, for me Python is worlds easier.

              I hate Python, don't ask me.

              1 Reply Last reply Reply Quote 0
              • Reid CooperR
                Reid Cooper
                last edited by

                Python is generally considered good for this task but lots of languages would do the work just as well. Ruby, JS, Perl, Tcl and even big platform languages like C# or Java. Whatever language you now will be better than one that you do not.

                1 Reply Last reply Reply Quote 0
                • scottalanmillerS
                  scottalanmiller
                  last edited by

                  If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that.

                  JaredBuschJ 1 Reply Last reply Reply Quote 0
                  • gjacobseG
                    gjacobse
                    last edited by

                    I haven't 'taken' to any type of programming since Basic on the Apple ][e or batch in DOS 3.1 / Windows 95....

                    Looking at code makes me 'dizzy'...

                    1 Reply Last reply Reply Quote 0
                    • JaredBuschJ
                      JaredBusch @scottalanmiller
                      last edited by

                      @scottalanmiller said:

                      If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that.

                      I dislike any whitespace delineated language.

                      scottalanmillerS 1 Reply Last reply Reply Quote 0
                      • scottalanmillerS
                        scottalanmiller @JaredBusch
                        last edited by

                        @JaredBusch said:

                        @scottalanmiller said:

                        If you learn a language just to do this, Python would be my recommendation. Specifically well suited to learning, good for doing small scripts of this nature and good for list processing like this. It's just a good fit. But yeah, if you know some other language already, definitely go with that.

                        I dislike any whitespace delineated language.

                        I do hate that aspect of it, very Fortrany, but it does make readability a clearer priority for the newbies and can have benefits, especially when working in teams of non-full time programmers.

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post