I need to automate a process which imports a new excell spreadsheet every
day. The spreadsheet has blank columns so access ( macro -transfer
spreadsheet) assigns fieldnames "noname1", "noname2" etc.
The spreadsheet also has in its first row abbreviations such as DEPT. (with
period) which access turns into DEPT#.
How can I get the xls imported without the blank collumns and with just
"DEPT" (no period)??
Any ideas will be appreciated.