How to Import Data from Excel using VBA : MS Access

hello my name's Joe on in this video we show you how to import data for Microsoft Excel to make a song exists not a base how by using the visual basic application you just click one button and import now data for Microsoft Excel to the table in Microsoft Access first go to design view and I'll be using the test page that I have it available and click on button and drag it here and which is cancel here and we you saw give for another phone exhale okay we have the one button and on the creaky wing under even procedure we put the code here before we put a code we need to know the file name or make yourself exhale fine where it's located I have to find him under download folder is a Prada we have the five products here under Adaro and username is a one or you can click here and pull up we need the location of this one you can see here is location is C use of and download and slash and put up me we can copy him okay we put the coat here Clearwater boudin 5-part a string okay five hot equal to odd the book or C slash up or down dot X + 6 X now I say we we sigh dislocation too far apart Bible and use the do seem d dot son foods the Sun for the spiritual act import and this time soon we skip that and table name we as you know important we import to the new table name we need to name the table by renamed in corn from pixel name table in Microsoft Access as sign code for mixer okay finding fine name will be Phi part we just have that and has your name too okay that's it we save and trombe you in here I don't have a pot of tables now we click on import data from Excel we just fit it in put the code in there now you can see this table import from Excel table which is created after we click the button let go it's same information from up products excel file which is have ID supply ID for the corporate name and in here will be the same thing now it's done we delete this one they did a table the next step to implement the code in the case we don't have the product fine in this forum it just delayed this one somehow we don't have the coordinate the phi x fi in here we hit this quote we keep import here we get the message for Microsoft Visual Basic dad runtime error database and she could not fight object this address make sure that object exists and you will spill this his name of hardening correctly and debug go to this mean this core try to locate the file and then confine which the message which is not down not friendly user we can use it along massive and go to the pump we don't need to see that it we need to program to check the file if this fire not exist in the photo and just get the pop-up the message that final file please check Phi again something ADA but what we need to do we need to implement the core of it if before we need the function that to check the file if this is x axis the function is we can go shoot online I use Google and we we be if I exist how how to determine if a faxes in visual basic form a casaba website it just click here and this one they have the function here for you already under you know Microsoft developer no network we copy this code to chip fights existing in baby ok copy is the functions are come here function in function copy we put down here function is come with the one line but we just entered the comments per diem or next step on learner comment leave this function now we got the code function of Phi exists to theta V finances and being how we use this function in our code we use Eve five exes my name is a Python then and do this own and if here with the spawn by not exist or not far peace ship finding or by location okay save it and now it is in the quick here we don't have the file on location Oh the message we don't have s in here which is this function Phi X s make sure that we got the right name see you get the message final file fishing file name or file location is more use of ending than system messes go back I have the fine here we copy that and they click important I have the file photo now it's a uniform mix up exhale to a table that I name import from Excel one more thing under the location in here if I have a/c users last a one it's me my using my vlogging computer download Kota how about if somebody else or you know network and other people they have fire under their car Road folder and they're using they may be different from my user and that one when they will click on that button okay but Ania the course not remove because this their uses different from my user but what we need to do we need to use the to get username from the login computer dim user has string ok s I use equal to environ username in my one user name this function we get the username from the computer login you to computer and that user can assure si to the user now we take out and replace the user with my user we have the procore and use and double cool so we're okay I delete this table game and now we try to import in with my new poll click import data from Excel now we got a new table which is important it's working the same as my username but this code is work for everybody using the computer network thank you for watching

Channel: T Golden Eye

Views: 88,628

Rating: 4.6336994 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, How to import data from excel, import using VBA, import data from excel, import from excel, import data, import data from excel using vba

Id: PhpZQw1ktP4

Length: 13min 13sec (793 seconds)

Published: Wed Jan 08 2014