Thank you for your great explenations! I love your work, it is a big inspiration. Your little jokes and Star Trek references put a smile on my face every time. I have a question. In your vid. you show that you are able to edit the Excel File with MS Excel (while Acces is open), then the changes become visible in your Acces database. In my database, I cannot make changes in the Excel file with MS Excel, when Acces is opened. Then I can only open the Excel file in read only mode. When I close Acces, then I can make changes in the excel file with MS Excel. When I re-open Acces those chages become visible. I cannot figure out why my acces behaviour is different than in your vid.
Every time a nice video to do something in access. The problem with this is that when there is somebody working in the excel Access can't read the data, so hope there is a way that access only do a read only on the excel so that the excel is still usable, but until now didn't find it.
@@599CD Sorry i was a little it unclear what i ment was is there a way that access is accessing the excel as read only so that other people still can edit the the same excel at the same time i'm in access?
Excellent video, please make video on how to filter continuous form with filtering criteria in 2 or 3 columns of drop-down lists and with two date range please. Thanks for your videos, your videos are excellent..
Not really. You could make a Union query, but that's just messy. If you're at the point where and Excel sheet is "full" then you really need to start bringing all of that into Access.
I have a source data like this in excel. What I would like to do is create a table with the source records (dont want to change the source) but have additional columns to add to the data within access. Is there a way to do that?
I have a 21k record spreadsheet, which includes a boolean field. When I use LINKED excel to access, it breaks and fills my data with '#ref' error. is it possible to link to boolean?
The MS ACCESS tutor of our generation. Keep the good job
Thank you, I will
Thanks for the videos Richard.they are very helpful.
Glad you like them!
I like MS Access so much, thank for your video!
Welcome
6:10 I see what you did there!
Nice presentation of the bassics I must say! Nothing too rushed!
Ha ha. Nice! :)
Thank you for your great explenations! I love your work, it is a big inspiration. Your little jokes and Star Trek references put a smile on my face every time. I have a question. In your vid. you show that you are able to edit the Excel File with MS Excel (while Acces is open), then the changes become visible in your Acces database. In my database, I cannot make changes in the Excel file with MS Excel, when Acces is opened. Then I can only open the Excel file in read only mode. When I close Acces, then I can make changes in the excel file with MS Excel. When I re-open Acces those chages become visible. I cannot figure out why my acces behaviour is different than in your vid.
599cd.com/ask
Every time a nice video to do something in access. The problem with this is that when there is somebody working in the excel Access can't read the data, so hope there is a way that access only do a read only on the excel so that the excel is still usable, but until now didn't find it.
Access usually has no problems reading and writing Excel data
@@599CD Sorry i was a little it unclear what i ment was is there a way that access is accessing the excel as read only so that other people still can edit the the same excel at the same time i'm in access?
Excellent video, please make video on how to filter continuous form with filtering criteria in 2 or 3 columns of drop-down lists and with two date range please.
Thanks for your videos, your videos are excellent..
599cd.com/SearchSeminar
is there a way to continue the linked table in the next excel sheet in case that the original one is full? thank you in advance
Not really. You could make a Union query, but that's just messy. If you're at the point where and Excel sheet is "full" then you really need to start bringing all of that into Access.
I have a source data like this in excel. What I would like to do is create a table with the source records (dont want to change the source) but have additional columns to add to the data within access. Is there a way to do that?
You can make a table in Access and then join that with your linked Excel sheet 1-to-1.
But is possible to mantain the excel cell format in the access table and next to the access form?
Possible? Yes. Easy? No.
@@599CD thank you and how?
Sir, plz make a video on how to get SAP table data into MS Access
599cd.com/Import
I am trying to link my Excel spreadsheet to an existing database. When doing so I only get one record imported to Excel from Access.. Please help!
599cd.com/Ask
I have a 21k record spreadsheet, which includes a boolean field. When I use LINKED excel to access, it breaks and fills my data with '#ref' error. is it possible to link to boolean?
If you've got 21k records, it's time to lose Excel and just IMPORT your data to Access and work with it there.
How can I link an Access query to an Excel spreadsheet?
Can't be done easily. You'll have to export the query data as a spreadsheet file from Access.
How to link a password protected access database to Excel????
Good idea for a future video.