importing data from excel file and storing in Ms-Access database table?
-
does anybody knows how to import data from excel file and store it in a Microsoft Access Database Table. plz help me with this. thnx Aakash
-
does anybody knows how to import data from excel file and store it in a Microsoft Access Database Table. plz help me with this. thnx Aakash
Open a blank DB Go to New Import table Navigate to the excel file you want imported Click import A wizard will now open asking things like "use top row as headings", etc. Follow the wizard and your table will be there :)
I've always heard that there was an idea behind Win ME... I still can't figure out what that was... anyboy know??? I;ve herad the idea was that it was supposed to be n operating system but I doubt this. - Brian Delahunty
-
does anybody knows how to import data from excel file and store it in a Microsoft Access Database Table. plz help me with this. thnx Aakash
Hmmm... you emailed me, but no message here. Oh well - hopefully this helps. Sorry, I didn't realise you were asking for code, as your question only asks how to do it. What I do (but perhaps I shouldn't spread this possibly bad practice) when I need code for VBA is open the program (in this case Access) and start recording a Macro. Then perform all the actions for importing the excel spreadsheet to an Access table. Stop recording the Macro, view the Macro code - it will give you everything :-D Hope that is of more use to you :)
I've always heard that there was an idea behind Win ME... I still can't figure out what that was... anyboy know??? I;ve herad the idea was that it was supposed to be n operating system but I doubt this. - Brian Delahunty