How to connect to a semicolumn separated CSV file form ms-access











up vote
0
down vote

favorite












What do I need to add to 



DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _

    fileName:="c:myFoldermyFile.csv", _

    HasFieldNames:=True


if the fields in c:myFoldermyFile.csv are separated by ;?






csv ms-access delimiter







share|improve this question


























    up vote
    0
    down vote

    favorite












    What do I need to add to 



    DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
    
    fileName:="c:myFoldermyFile.csv", _
    
    HasFieldNames:=True


    if the fields in c:myFoldermyFile.csv are separated by ;?






    csv ms-access delimiter







    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      What do I need to add to 



      DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
      
    fileName:="c:myFoldermyFile.csv", _
      
    HasFieldNames:=True


      if the fields in c:myFoldermyFile.csv are separated by ;?






      csv ms-access delimiter







      share|improve this question













      What do I need to add to 



      DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
      
    fileName:="c:myFoldermyFile.csv", _
      
    HasFieldNames:=True


      if the fields in c:myFoldermyFile.csv are separated by ;?






      csv ms-access delimiter




      csv ms-access delimiter






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 15 hours ago









      Dirk Horsten

      2,1951228




      2,1951228
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          Link the file manually using the wizard. Specify the separator as semicolon.



          Save the import specification. Remove the link.



          Now, specify the import specification to use when creating a new link:



          DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
          
    fileName:="c:myFoldermyFile.csv", _
          
    HasFieldNames:=True, _
          
    SpecificationName:=YourImportSpecification





          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














             

            draft saved


            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53265976%2fhow-to-connect-to-a-semicolumn-separated-csv-file-form-ms-access%23new-answer', 'question_page');
            }
            );

            Post as a guest


















            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote













            Link the file manually using the wizard. Specify the separator as semicolon.



            Save the import specification. Remove the link.



            Now, specify the import specification to use when creating a new link:



            DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
            
    fileName:="c:myFoldermyFile.csv", _
            
    HasFieldNames:=True, _
            
    SpecificationName:=YourImportSpecification





            share|improve this answer

























              up vote
              0
              down vote













              Link the file manually using the wizard. Specify the separator as semicolon.



              Save the import specification. Remove the link.



              Now, specify the import specification to use when creating a new link:



              DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
              
    fileName:="c:myFoldermyFile.csv", _
              
    HasFieldNames:=True, _
              
    SpecificationName:=YourImportSpecification





              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                Link the file manually using the wizard. Specify the separator as semicolon.



                Save the import specification. Remove the link.



                Now, specify the import specification to use when creating a new link:



                DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
                
    fileName:="c:myFoldermyFile.csv", _
                
    HasFieldNames:=True, _
                
    SpecificationName:=YourImportSpecification





                share|improve this answer












                Link the file manually using the wizard. Specify the separator as semicolon.



                Save the import specification. Remove the link.



                Now, specify the import specification to use when creating a new link:



                DoCmd.TransferText acLinkDelim, tableName:="myLinkedTableName", _
                
    fileName:="c:myFoldermyFile.csv", _
                
    HasFieldNames:=True, _
                
    SpecificationName:=YourImportSpecification






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 15 hours ago









                Gustav

                28.6k51734




                28.6k51734






























                     

                    draft saved


                    draft discarded



















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53265976%2fhow-to-connect-to-a-semicolumn-separated-csv-file-form-ms-access%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest






































































                    -

                    Popular posts from this blog

                    mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924

                    Image
                    0 I just uploaded a new plugin to my wordpress site and I got this warning: mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924 Usually if I have a problem, I can find answers on google but this one seems pretty particular and I'm not finding any info on it except for this forum. I'm not terribly techie but if someone can tell me how to read this and how to change it I can follow directions pretty well. Thanks All! PS If I don't have the proper tags here could someone add the appropriate tags? php mysql wordpress share | improve this question asked Nov 16 '18 at 20:41 ...
                    Read more

                    How to change which sound is reproduced for terminal bell?

                    Image
                    3 Recently upgrade to 18.10 from 18.04, and using the terminal is becoming annoying: the new alert sound is a drip ( /usr/share/sounds/gnome/default/alerts/drip.ogg ), and the previous one is still located at ( /usr/share/sounds/ubuntu/stereo/bell.ogg ). My issue is that at the gnome-terminal, when autocompleting or pressing left BOTH sounds are reproduced, at the same time. I want to just have ubuntu/stereo/bell.ogg active, not both . At the moment I have been only able to reduce the volume of the alerts (but still both are played), or turn the alerts down (but I dislike both "solutions"). gnome-terminal 18.10 teminal-bell share | improve this question ...
                    Read more

                    Can I use Tabulator js library in my java Spring + Thymeleaf project?

                    Image
                    0 I want to add Tabulator js to my java project. I added tabulator.min.js, tabulator.min.css to resources folder. After that added to my html page these dependencies as recommending in readme.md. <link rel="stylesheet" th:href="@{/css/tabulator.min.css}"> <script type="text/javascript" th:src="@{/js/tabulator.min.js}"></script> Now my tables view all elements, that I have in the html page, but not correct. In the documentation of Tabulator is example how to create header and table, var table = new Tabulator("#example-table", { columns:[ {title:"Name", field:"name", sorter:"string", width:200, editor:true}, {title:"Age", field:"age", sorter:"...
                    Read more