i have posted previously with a similar request , and i am still trying on my own.
i want to import one table fully from a particular MDB ( access ) file.
i recorded a macro to that efect which looks like this.
Now the table extracted by this is "frame section assignments which is what i want.
but the path of the mdb file is fixed in the above code.
i want to make it user select or variable as per user so i modified it to the following code.
but it doesnt work.. it searches for a file named "filename1.mdb"
and it gives error.
I Think my mistake lies somewhere in
DSN and DBQ and Default Directory
do guide me on this one...
thanking you all in advance.
--
From,
SSP
Bookmarks