I have two main problems -
(1) I am trying to import Excel files into access - by using the Import function- "The error message I get is "Method Columns of object iimexgrid failed".
If I use the transfer spreadsheet command - I get an error aroudn naming conventions.
(2)What is the simplest way to allow the user to select directory path and filename of these excel files to be imported.
Thanks in advance
Guv
(1) I am trying to import Excel files into access - by using the Import function- "The error message I get is "Method Columns of object iimexgrid failed".
If I use the transfer spreadsheet command - I get an error aroudn naming conventions.
(2)What is the simplest way to allow the user to select directory path and filename of these excel files to be imported.
Thanks in advance
Guv