|
#1
|
||||||
|
||||||
|
A little help with MS Access
I want to import an .xls (Excel) file into an Access Table. The first row of the .xls file contains the column names. I know this can be done manually by clicking on File -> Get External Data -> Import. But, I have to automatize this...I'm thinking of using a Macro, but I don't know which Action to associate with the Macro.
Any help would be GREATLY appreciated.
__________________
And those who have no knowledge say: "Why does not Allah speak to us (face to face) or why does not a sign come to us?" So, said the people before them words of a similar nature. (Because) their hearts are alike. We have indeed made clear the signs for people who believe with certainty. [The Glorious Quran, AlBaqarah:118] |
|
#2
|
||||||
|
||||||
|
Transfer spreadsheet I believe should do it
|
|
#3
|
||||||
|
||||||
|
(edit)
thanks!
__________________
And those who have no knowledge say: "Why does not Allah speak to us (face to face) or why does not a sign come to us?" So, said the people before them words of a similar nature. (Because) their hearts are alike. We have indeed made clear the signs for people who believe with certainty. [The Glorious Quran, AlBaqarah:118] |
|
#4
|
||||||
|
||||||
|
commay, you tha MAN!!!!!!! thank you :1:
__________________
And those who have no knowledge say: "Why does not Allah speak to us (face to face) or why does not a sign come to us?" So, said the people before them words of a similar nature. (Because) their hearts are alike. We have indeed made clear the signs for people who believe with certainty. [The Glorious Quran, AlBaqarah:118] |
|
#5
|
||||||
|
||||||
|
no problemo boysie
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|