Fabulous timing, Richard! I've used your excellent teaching videos to teach myself how to create a Budget db for my own personal use which imports csv files where I then add categories and subcategies for spend.
13:00 😂 Its early AM in the UK but watching this, it seems counter intuitive that you're pulling records from your CustomerTempT form in to your CustomerT form, but when you look at the Query it says "Update To" field is CustomerTempT. Maybe I need a coffee and have a rewatch, is it just me, is it too early? Lol Anything great teaching video!!! Thank you.
Thanks Richard! Would it be possible to show how to choose a specific file to import by using FileDialog? Goal is to completely replace the data in a table periodically by just importing a new file.
@@599CD in my country there is no problem if you say some color but now I see, north American People have problem with this, I'm sorry I wrote like a Colombian
No no no... I was just joking... kidding... here in the US, when someone says something, anything, with either "white" or "black" in it like that, it's a silly joke to just say "that's racist, man." Just ignore me. I know it doesn't translate to other languages / cultures. If you want to import the NON-EMPTY cells only, it all depends on how you have your sheet set up. I would personally import EVERYTHING into Access and the sort it out there. Much easier than trying to get the sheet right.
I have One Trouble. Im Using a Software which uses CSV File for Data Import and use Access. But CSV File Sometimes Contains Wrong Data so I Have to Change it Many Times In CSV. Particular State name. I want use State name for Every Entry Same. Even if the csv have Other name State or Blank in State Column. I tried many Things But Didnt Find Anyting. And also i cant use Query and Another Thing because i use access from another Software. So theres just one way to change data when importing. is there any way?
Thanks for the video Richard! I always learn something watching your videos! 🖖
Fabulous timing, Richard! I've used your excellent teaching videos to teach myself how to create a Budget db for my own personal use which imports csv files where I then add categories and subcategies for spend.
Thanks that was very informative our dear instructor! Thumbs up!
I liked and shared!
Thanks for the presentation, I do appreciate your video.
Thanks
Great,
it will import formatting too ?
Thanks for this video
You're very welcome
13:00 😂 Its early AM in the UK but watching this, it seems counter intuitive that you're pulling records from your CustomerTempT form in to your CustomerT form, but when you look at the Query it says "Update To" field is CustomerTempT.
Maybe I need a coffee and have a rewatch, is it just me, is it too early? Lol
Anything great teaching video!!! Thank you.
El Fantastico ❤
Thanks Richard! Would it be possible to show how to choose a specific file to import by using FileDialog? Goal is to completely replace the data in a table periodically by just importing a new file.
Yep. I cover this in the extended cut for 599cd.com/images
is it possible to import data from excel if the data is only from a certain range?
Automated with just one click ! Is this a new definition for automation ?
I want to learn Access course and wish to sign in as a beginner
Kindly help how do include primary key in that statement in access =Nz(DSum("[tithe]","TitheTable","Quater='quater 1'"),0)
Should it be acLink, not acImport? I think acImport overwrites a table??
Can this process be done to automatically import data from website to ms access?
Not this process specifically but it's definitely possible
great, I want to know how to import without white cells in excel?
That's racist
LOL. What do you mean "white cells?" You mean colored white, or EMPTY? Either way: 599cd.com/Ask
@@599CD I'm from Colombia, I mean blank cells or empty cells I don't understand why you say about racist, sorry by this
@@599CD in my country there is no problem if you say some color but now I see, north American People have problem with this, I'm sorry I wrote like a Colombian
No no no... I was just joking... kidding... here in the US, when someone says something, anything, with either "white" or "black" in it like that, it's a silly joke to just say "that's racist, man." Just ignore me. I know it doesn't translate to other languages / cultures.
If you want to import the NON-EMPTY cells only, it all depends on how you have your sheet set up. I would personally import EVERYTHING into Access and the sort it out there. Much easier than trying to get the sheet right.
I have One Trouble. Im Using a Software which uses CSV File for Data Import and use Access. But CSV File Sometimes Contains Wrong Data so I Have to Change it Many Times In CSV. Particular State name. I want use State name for Every Entry Same. Even if the csv have Other name State or Blank in State Column. I tried many Things But Didnt Find Anyting. And also i cant use Query and Another Thing because i use access from another Software. So theres just one way to change data when importing. is there any way?