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

    Data Export from Database

    IT Discussion
    microsoft access excel csv
    5
    17
    4.7k
    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.
    • DustinB3403D
      DustinB3403
      last edited by

      LibreOffice is cross compatible.

      The only trouble you'll have is ensuring that your Export function works in both Libre and Office. CSV is a universal format so that isn't a problem.

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

        I agree, the first things to avoid once you are talking about cross compatibility are MS Office, Excel, etc. Those are specifically not cross compatible.

        LibreOffice Calc is super easy and very powerful to use, works mostly just like Excel, but runs everywhere and is free.

        Could be a spot for a simple project in Python or similar too.

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

          @scottalanmiller said:

          I agree, the first things to avoid once you are talking about cross compatibility are MS Office, Excel, etc. Those are specifically not cross compatible.

          LibreOffice Calc is super easy and very powerful to use, works mostly just like Excel, but runs everywhere and is free.

          Could be a spot for a simple project in Python or similar too.

          Python, interesting. Don't know anything about it.

          Wonder if I could just use a spreadsheet and run an export using excel / liber office.

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

            @gjacobse said:

            Wonder if I could just use a spreadsheet and run an export using excel / liber office.

            Yes, you can.

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

              As someone that does not code - would you have any suggestions on how to perform the following:

              • import multiple CSV files to database
              • sorting
              • export to single CSV file
              scottalanmillerS 1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller @gjacobse
                last edited by

                @gjacobse said:

                As someone that does not code - would you have any suggestions on how to perform the following:

                • import multiple CSV files to database
                • sorting
                • export to single CSV file

                A CSV mimics a spreadsheet, not a database. It is flat. Importing a CSV into a database on its own doesn't really make any sense. What is the reason for having a database if it CAN be converted to CSV?

                1 Reply Last reply Reply Quote 0
                • 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