Bonjour I want to connect data base access it's has password with excel an error message appears "we encountered an error while trying to connect password not valid knowing that I did not enter the password where I can enter the password let me know please it's important for me
I understand your comment but have a question. Since excel only updates when the file is open why would you want to connect Excel to Access? Could you copy the information from Excel into Access directly instead of linking it? I only see the benefit of connecting Access to Excel.
@@PhilipHubbe hi I’m a data analyst and use excel all the time for data analysis. Although excel is great for data analysis it’s terrible and inefficient for data entry especially when you have to enter the same thing multiple times. This is why excel is capped at 1 million rows whereas access is unlimited. I find it’s much much more efficient to enter and manage my data in access and if I want to analyse it, rather than copying and pasting it into excel like you suggested, it’s already linked so when I open it it’s up to date and ready for analysis
Great video, thank you!
Thank you, I’m glad you’ve enjoyed it!
Can we have connection from excel to access? I want to have connections.
Use link table
Bonjour
I want to connect data base access it's has password with excel
an error message appears "we encountered an error while trying to connect
password not valid
knowing that I did not enter the password
where I can enter the password
let me know please it's important for me
bla bla bla
content is irrelevant for the title.
I understand your comment but have a question. Since excel only updates when the file is open why would you want to connect Excel to Access? Could you copy the information from Excel into Access directly instead of linking it? I only see the benefit of connecting Access to Excel.
@@PhilipHubbe hi I’m a data analyst and use excel all the time for data analysis. Although excel is great for data analysis it’s terrible and inefficient for data entry especially when you have to enter the same thing multiple times. This is why excel is capped at 1 million rows whereas access is unlimited. I find it’s much much more efficient to enter and manage my data in access and if I want to analyse it, rather than copying and pasting it into excel like you suggested, it’s already linked so when I open it it’s up to date and ready for analysis