How To Import An Excel Spreadsheet With VBA In Access 2013 🎓 

Looking for DAILY content? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: ru-vid.com/show-UCeXAUvo5xxDY_b-lSknPC1A

This is the best of the best VBA tutorial that I have ever seen. It's step by step and the instructions are clear. You saved my graduation project, thanks man.

One of the best tutorials for Access VBA I ever have seen. Very simple and excellent step by step explanation. Great

Excellent tutorial Mr. Steve Bishop. I wish you had another one just to append records to that table created first time so that I could do things that way for the office that I work for.

This is LEGIT the most helpful access how to I've watched! thank you so much for putting out quality tutorials!

I love this! He went fast, so I did not have to sit an wait.... and I could always pause it if I needed to slow it down. The explanations are so GREAT! I am not well versed in vba, so this was perfect! Steve should be a professor! :)

A pedagogic, intuitive and good tutorial. Thumbs!

I have a question, what if we get a file that has more than one sheets, how do I get the data from sheet 2 for example?

Hi Steve, one word of comment: great! Thank you for this explanation and good and simple example.

Thanks for sharing this valuable knowledge. I was wondering for this only since long. Finally I got it. Thanks a lot once again.

This is very well done including setting up the references which can be easily overlooked, and cause issues.

You are good teacher

Another great vidoe Steve. One thing to consider in the filter settings is to include "*xlsm" and"*.xlsb" files. The second is not very common, but many data collection spreadsheets are macro enabled.

Absolutely amazing, thanks Steve for the amazing tutorial

Es lo mejor que he visto en toda mi vida en VBA en macros en Access mil gracias por el ilustrativo.

You just made my day bro...great, thanks 👍

Great video. THANK YOU. How to append new data to existing table from excel file?

Omg - To the point... Top notch explanation... Thank you Sir!

Hi Steve, an excellent video. I was looking for exactly same thing and all scenarios I found in a single video ... thanks a lot!

Thanks tNice tutorials helps alot man!!

save me alot of time, had to figured out how import just 1 sheet

Steve, an absolutely amazing video.

hi dear steve that was so good , I just have a question. when i click on import Spreadsheet button it works with no error and microsoft access make a table , now if i click on it one more time the table duplicate , how can i prevent this action? how should i change codes? i will preciate if you can help me on this . can you make a video about how to append data from excel to access table in the same way? thanks and sorry for my english

This is the best video tutorial.

Thanks for this tutorial! it was exactly what I was looking for.

Hi Mr. Bishop Thank you for all the videos. Could you make a small video explaining how to export access query with begining date and ending date criteria to an existing file in excel. Thanks a lot

Excellent lecture

Hi Steve, Very new to VBA - im pretty clued up on Excel Formulas and Power BI DAX but never really dabbled VBA. I have spent a few weeks looking for a CLEAR step by step guide on how to not only write vba to import from Excel to Access but also explanations of each step along the way. I have found this video super informative and wanted to thank you for taking the time to make such an easy to follow guide. I do wonder though - this method "Pulls" data from Excel to Access - do you have any videos on how to Push from Excel to the Access database at all.... Essentially I have around 20 spreadsheets for different customer account ( helpfully the columns are not in the same order either ) and I wish to add these files into a master access DB by adding a macro button onto each file so users just click " send to DB" after completing a line - further caveat, this needs to only "Push" the last used roq and not the entire table. I also need the flexibility to say that on spread sheet 1 Column A = first DB column but on spread 2 column D for example = first DB column. I imagine I would have to write custom ranges into each VB code on each sheet to achieve this,,, Sorry for ranty comment but any assistance would be GREATLY appreciated, Thank you again for the great vid Steve! From Steve!

Wow that was EXCELlent, even tho it was performed on MS Access You're great

Thanks but one question.. I dont want a bunch of tables so how would I delete the old table if it exists? The method you provided just creates a number at the end of each new table. Thanks!

Thanks a lot friend.. that was really useful to me...

Thank you for a thorough explanation. It would be great to see an explanation of appending Excel data to an existing table. Also, I would really like to learn how to append data to multiple tables from a single Excel file. For example, let’s say if I’m storing customer names in one table, in another table I’m storing provinces and a third table contains all orders. Is it possible to append new information to all three tables from a single imported spreadsheet?

awesome and to the point

This a great video! Do you have video that shows how to import data from an Excel file where you only want data from certain columns that may or may not be in series?

Hi, Thank you for this video! When I import a Excel spreadsheet, is it possible to import it to an existing table instead of creating a new one as "Me.textFileName"? I also wonder if I can map the excel spreadsheets columns to another in the table, for example the column "Amount" should go to the column "Rate" in the table and if a cell is blank it should put in a value as "0"? I have tried to look in your other videos but can not find something like that, if you already have a video for that I ask, can you please link it? Thanks in advance!

Thank You! Very good tutorials.

Hey, talking about the range of cells in excel to import, how could I select just the columns that I need ?

Excelent demonstartion of VBA in Access. Q If the first row of the excel spreadsheet contains rogue data and the 2nd row contains the column names how do I get access to ignore that first row

nice video tutorial, sir could you please tell me how to import data alreadey exist table, much apreciated if you explain

excellent video!!!! thanks a lot

one question if I have a many worksheets and I need to import the worksheet that not be the first of them?

I know it's been a few years, but acLink is a good option to create a temporary table if Access is having problems casting the datatype for a particular field. I've found that if you pull it in as a link and then append the data to a table, then destroy the link, it works a lot better. Doing this, you can use a file picker to grab the file name any time you want to import/update

Hey.. How to create and import the data into same table always???

Hi this is very useful to me . Just now I start learning access. I have doubt in this video importing the excel file in separate table for me. Excel data should be import in single table. Can you plz help me on this....!!

How can I add the navigation bar you are using?

I tried to import an ".xlsx" extension format but it didn't work, the docmd.TransferSpreadsheet didn't work with that extension, Could U please give me a solution???

Thank you for the video! I've tried using this feature at work, but unfortunately I don't know how I can get it to work with access running via RDP as a remote app. Users are unable to select any files located on their hard drive. Is there anyway around this?

Unfortunately the Open File Dialog did not function correctly for me with the coding supplied, I entered, checked and re-checked and compiled the coding and it is exactly the same at displayed, with no errors, but I had the peculiar effect of the dialog box opening twice, the first time it did not fill in the text file but the second time it did. After extensive tracking with '"stops" and "msgbox" commands inserted in different locations in the coding I am afraid that I have not arrived at the solution for this weird effect. I was wondering if anyone else has had the same effect. I am running Office Professional Plus 2016.

Hi Steve. Thank you for this good tutorial. I just wanted to comment on using "for each loop" after file dialog. I have been using the file dialog with allowmultiselect=False without for each loop and it works. Did you test that?

Great content surpose i what to import to existing table?

Hi, do you have any clips related to unstructured data from a text file? I really want to update the MsAccess app that helps me in the Eu4 game with tons of modifiers that are stored in some files that have structure somehow similar to JSON files. I would really enjoy data mining them using VBA and automatically update my MSAccess tables. Would be really really great if you can do a clip on this topic.

Very nice video. Thank you.

Can you show How import Excell file to existing Table using VBA in Access 2013 ?

Great video!! Q. how would you use the same method for appending an existing table?

I have a question of second part of the import excel spreadsheet document. That is about ImportButton. Here there is a code where I recieve an error while debug it. The debug is signals in Me.txtFileName part. If FSO.FileExists(Me.txtFileName) Then ExcelImport.ImportExcelSpreadsheet Me.txtFileName, FSO.GetFileName Original representation of code is, Private Sub btnImportSpreadsheet_Click() Dim FSO As FileSystemObject If FSO.FileExists(Me.txtFileName) Then ExcelImport.ImportExcelSpreadsheet Me.txtFileName, FSO.GetFileName End If DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Dyeing", Me.txtFileName, True, strSelectedWorksheetName & "!" End Sub Thank you very much if anyone can answer it.

Hi, Do you have any Videos on Importing a CSV file? I thought maybe i would use the same method but the problem is that you said "IT HAS to be an Excel file?"

Excellent Video! So if I were wanting to import Excel into an already created table, how would I code it? Also, where would I put the logging code...the very beginning or the end?

Right here with ya, bro

Hi Steve again! I just could not use /CurrentDb.execute "Drop Table " before importing./ in order to delete the already existed table. could you show us this practically?thanks.

thank you so much

thanks, sir, after we upload excel file can we rename the table? thanks for given a vba code

hello I have a question, how can I if I order an exel file and paste into your Access Exel file with your written - How To Import To Excel Spreadsheet With VBA In Access 2013 ??

Hello, I am getting an error code Run-Time err 438...... object doesn't support this object or method... Set diag = Application.FileDialog(msoFileDialogFolderPicker) diag.AllowMultiSelect = False diag.Title = "Escoger Archivo" diag.Filters.Clear diag.Filters.Add "Excel", "*.xlsx" --> here is whe i get the error when I click on the boton. Can you guys help me out??/

hello , I can not found the method me.txtFileName Can Anyone help?

Hi Steve, every time I import the excel, a new table is created. Please advise how to code such that the content of the access table is deleted and replace by the imported excel file.

I have issue with Filter.add And Me. Methods can you help me out with this I Thanks in advance

Steve. Thank you for posting this video. I get an error on Me.txtFileName. "Method or data member not found." The intellisense does not recognize this property. I have added the reference to Microsoft Office library 16.0. Can you suggest how to resolve this error? Thanks

I am getting a compile error at the "for each" statement. Assist plz.

Hi Sir Steve.. what if I import the excel worksheet and has a 5 sheets.. and i need only 1 sheet from this work book?

Thanks man

dude u rock

Thank you!

just awesome

misconceptions that the comnt is supposed to soft like I am in love with Nice tutorialm or sotNice tutorialng.

hi, how can add the values from an excel spreadsheet to existing table? very urgent please

great viedo

Can You please share the code

genious

The worst tNice tutorialng soone can do after starting is quitting... never give up and the rewards will be greatly appreciated

Not bad.

This guy sounds exactly like Steve Jobs

This is one of the best videos! Excellent Job

I talked myself into being responsible for creating a new database for work, without having any clue about this stuff. You, sir, saved my life with videos like this one. They way you quickly explain every line of code and every expression, even if it's not needed, perfect for beginners and good for general learning! Thank you!

Why in Excel 2016, diag.Filters.Add "Excel Spreadsheets", "*.xls, *.xlsx" is giving me Object doesn't support this property or method....Run-time error 438:

This great! Thank you! Could you also show how to import multiple Excel files, and also only import the sheet (or Tab) the user wanted?

Fantastic video!!

Since an Excel spreadsheet can have multiple tabs (or pages), it would of been ideal if the import function called the individual tabs as separate tables into access rather than use the file name as the access db table name.

This man really is amazing, I hope more programming and data structure tutorials using c#.

Very useful for a beginner like me. Nice way to explain each step. I like it. Please keep it up.

For few weeks I am watching your videos and this one is really impressive, many many thanks for your extra-ordinary effort.

Excellent video! Thank you a lot! One more tip I just figured out: if you want to choose a specific WorkSheet from the excel file, you can write the spreadsheet name with an exclamation mark (e.g., "MyFirstSheet!") instead of leaving the range parameter (8:39) blank.

thank you for this course but when i click browse, display error excution '438' debug in command : diag.Filters.Add "Excel SpreadSheets", "*.xls, *.xlsx" help please

Thanks for the tutorial. It helps me a lot with my work. I have question, what if we import the same file name? can you show how replace the old file name? another question is that I have existing table in Backend file and want to import from from FrontEnd by appending only the new record. Do you have another VDO tutoring?

Hey! Excellent tutorial my friend. Thank you :)

While compiling it is showing error that "Argument not optional" at "ExcelImport.ImportExcelSpreadsheet" please help

Nice information.... Could you please help me to open pw protected access file using excel vba. I tried multiple ways Eventhough am not getting.. Can you please

This tutorial helped a lot but one problem the "Badformat" VBA code conflicts when trying to import an Excel currently opened by another user. Where it wouldn't be a problem I can see where this can be later down. Is there a way to check if file is being imported read only

There is "Codician" channel person has copied your code, Video name is "import data from excel to access vba on a click". I believe you should take the action on it. Such deep shit are copying your Codes.

thanks for this tutorial. it's the best tutorial I've ever seen, and it's very helpful. but I have a problem. if I want to import several excel files on the same access table, it only imports data on the first excel and it does not want to import on the next excel. it doesn't add any more data I need. there is a thoughtful view to this issue. thank you.

Ive watched tNice tutorials a couple tis and i tNice tutorialnk the key is to slow the video down to .75. TRY IT!!!