I want to select my (variable) columns from my Excel file and be able to transform paste into an Access table.
The easiest way would be to transform paste in Excel but for functionality I do not want to do this.
What I would like to do is to paste into a row table (that contains several columns), then transform this into another table either by a query or by looping a function.
Does anybody have any direction or advise for doing this.
Your time is appreciated in advance.
The easiest way would be to transform paste in Excel but for functionality I do not want to do this.
What I would like to do is to paste into a row table (that contains several columns), then transform this into another table either by a query or by looping a function.
Does anybody have any direction or advise for doing this.
Your time is appreciated in advance.