I have a table in txt format named table1. Table1 will keep changing to different name. File location is in C:\dbsouce\jm\table1.
The table structure is:
Can any body help me to develop a module to import the txt table? For example, if I have a form with a text box and a button, when user type in the txt table's name and click the button, the tex table would automaticly transfer to db1.mdb.