Hello Dudes
I am looking for a simplified macro to export first range of column of Excel 2007 into MS Access 2007
say like creating a file call test.xls within MY DOCUMENT folder and container MS Access test2007.accdb
& populating excel first column like A1 - ID & A2-A100- with numbers
how can i export the data range A2 to A100 into access, any help appreciate
i saw one macro on excelguru, when I copied the example shown there and tried in my computer (it showed run time error)
so a simple macro will I appreicate
I am looking for a simplified macro to export first range of column of Excel 2007 into MS Access 2007
say like creating a file call test.xls within MY DOCUMENT folder and container MS Access test2007.accdb
& populating excel first column like A1 - ID & A2-A100- with numbers
how can i export the data range A2 to A100 into access, any help appreciate
i saw one macro on excelguru, when I copied the example shown there and tried in my computer (it showed run time error)
so a simple macro will I appreicate