Connect to folder

[albertan]

Hello, I wanted to check with our respectful members if they could help me whether it's possible to have a direct connection with a folder where there would be one .csv file but it will be replaced every day with a new name.

It works with Power Query in excel, but lots of data, I wanted to try to see how it works with MS Access.

Thanks in advance!

 

[Joe4]

It would be far easier if the file always had the same name. Then you could just link the Access table to the CSV file by that name as shown here:

Import or link to data in a text file - Microsoft Support

Import or link to data from an external text file into Access.

support.microsoft.com

If it were me, I would create a subfolder, and schedule a daily job to copy whatever file is in the main folder to the subfolder, using the same name every time (so overwriting the old file).
So the linked table would always reflect the most recent data.

Either that or create a Macro or VBA procedure to delete the data from the current table and import all the files (which is only one) to your table every day.
Then you would just need to be sure to run that every day.

 

[albertan]

Does Microsoft Access has ability to connect to the folder? I don't think it does and I asked about if data is large it seems like MS Access works better

 

[Joe4]

Does Microsoft Access has ability to connect to the folder?

Not really sure what you mean by that. Does any program have the ability to connect to a folder? The data doesn't exist at the folder level, but at the file level.
If you identify a folder location, you could write VBA code to import all the files found in that folder into Access.

 

[Joe4]

If you look at the last reply in this link, it shows you how to import all the files found in a certain folder, regardless of their file name:

How to loop through a folder?

I want to loop through a folder and import all the files into Access. This is my code: Const ForReading = 1, ForWriting = 2, ForAppending = 8 Dim fso, MyFile, FileName, TextLine Dim TextArray() D...

stackoverflow.com

 

[albertan]

I want to connect to a folder with MS Access not through Excel ( like one can do through Power Query, where you can connect to a folder)
Can I please get answers from other folks who know MS Access thanks

 

[Joe4]

Can I please get answers from other folks who know MS Access thanks

I am afraid that you probably are not liekely to get much help with that kind of attitude!

I DO know Access, and all the links I provided are specifically for Access (have you even looked at any of them?).
So I am not sure where you are getting "Excel" from (unless you are referring to my signature that appears at the bottom of every post - that is a signature - it has nothing to do with the replies I have made).