In short: Is there a way to DoCmd.OpenTable without column headers?
In long...
I have MS Excel template with fairly complex header info I want the users to stay away from.
If I could wave a magic wand the user would "Press this accdb form's button, ctrl-A, ctrl-C, open the excel file, drop the cursor, ctrl-V, ctrl-S, then press X to close."
The problem is the user keeps forgetting to remove the table's field headers/column labels which hoses the data being submitted in the excel file.
Is there a way to docmd.opentable (to my linked sql server view) without copying the field names when I ctrl-C, or use the Copy button from the ribbon?
Thanks!
-Matt G.
In long...
I have MS Excel template with fairly complex header info I want the users to stay away from.
If I could wave a magic wand the user would "Press this accdb form's button, ctrl-A, ctrl-C, open the excel file, drop the cursor, ctrl-V, ctrl-S, then press X to close."
The problem is the user keeps forgetting to remove the table's field headers/column labels which hoses the data being submitted in the excel file.
Is there a way to docmd.opentable (to my linked sql server view) without copying the field names when I ctrl-C, or use the Copy button from the ribbon?
Thanks!
-Matt G.