read and display the columns in import file and allow the users t.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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/Th...m-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/Th...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
 
Back
Top