read and display the columns in import file and allow the users t. ARM 14.07.2006 14:45:01 I'm trying to program a command button cmdImport that when user click it (after check all the conditions such as check table if it existing, file path is correct, file type is right) it should read and display the columns in import file and allow the users to match them with the corresponding columns in the existing table. Is it possible in access? I need code as i am very new for this

Re: read and display the columns in import file and allow the users t. John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 15.07.2006 21:34:07 It's possible to do what you want, but not possible to do it all for you in a single newsgroup answer. You'll need to learn something about programming in VBA code, writing queries in SQL, and designing user interfaces. Also, you don't say what kind of files you are planning to import: that can make a big difference too. On Fri, 14 Jul 2006 07:45:01 -0700, ARM <ARM[ at ]discussions.microsoft.com> wrote: [Quoted Text] >I'm trying to program a command button cmdImport that when user click it >(after check all the conditions such as check table if it existing, file path >is correct, file type is right) it should read and display the columns in >import file and allow the users to match them with the corresponding columns >in the existing table. Is it possible in access? > >I need code as i am very new for this -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email.

Re: read and display the columns in import file and allow the users t. "SurendranSNV via AccessMonster.com" <u23007[ at ]uwe> 17.07.2006 11:00:43 Try the following earlier posts links where in I have given sample codes for handling text files in various scenarios. As John Nurick said, you should atleast have a basic knowledge of VBA programming to follow the sample code. This post provides sample code for reading a single text file and also multiple text files and insert in an Access table. http://www.accessmonster.com/Uwe/Threads/List.aspx/access-externaldata/11415/Import-from-from-text-file-into-access#6324e9c0f0e0duwe This post provides sample code how to read a text file with delimiters like !, tab,etc. http://www.accessmonster.com/Uwe/Threads/List.aspx/access-externaldata/11414/Importing-only-SOME-fields-based-on-Primary#6322d8f56ebfauwe This post provides sample code for reading multiple text files and append to a new text file. http://www.accessmonster.com/Uwe/Forum.aspx/access-externaldata/11352/Appending-Txt-files-coding Surendran SurendranSNV at Hotmail dot com ARM wrote: [Quoted Text] >I'm trying to program a command button cmdImport that when user click it >(after check all the conditions such as check table if it existing, file path >is correct, file type is right) it should read and display the columns in >import file and allow the users to match them with the corresponding columns >in the existing table. Is it possible in access? > >I need code as i am very new for this -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200607/1