1.-If i have 30 excel sheets, it a lot a work to pass them into access ? 2.-It is a lot easer to do it in power query, then attached it to access , to link them to diferents tables
This video would have been much more valuable had you given some of the most common errors users would get when their excel file is not formatted or saved properly for Access to import records! A common error most users will receive is “Subscript out of range”
1.-If i have 30 excel sheets, it a lot a work to pass them into access ?
2.-It is a lot easer to do it in power query, then attached it to access , to link them to diferents tables
This video would have been much more valuable had you given some of the most common errors users would get when their excel file is not formatted or saved properly for Access to import records! A common error most users will receive is “Subscript out of range”
Thank you, this was exactly what I needed.
You are very welcome! Thanks for watching 😃
Hi, is it possible to get data from an excel file attachment in an email to MS Access?
Did i seriously just watch a video to import Excel data, only to get to the end and be told we are not going to import data from excel....? Seriously?
Nice
👌👌👌
6/10 edge need better content