It's a weird situation that I don't understand. When we open the file it has an A column that is compressed to the left to where you don't even notice it when you open the file. I'm sure that I was not aware of it when I first linked it to an Access table. Btw - the data is shipment information...
Thanks Pat! Very interesting. I will take some time and see what I can modify to incorporate the the information that you have provided into the process.
We can delete column A. The hope was to just save the file from the email to the specified location and have no other intervention. Otherwise it requires opening the file each time and then deleting the column and saving it to the location. It's one extra step but it's annoying.
This is a weird one - may not be a great solution to it - wondering if anyone has any insight into this..
I have a database that uses an Excel file as a linked table. I have to use the Excel file as a data source as this information is sent from a vendor to us. The Excel file has column A that...
I believe this will work. I was hoping to not have to create the table with all of the extra dates but I can live with that.
Thanks to everyone who replied!
One last thing - if anyone cares to respond. I still have one last issue that I think I can work around (somehow). My table with the...
Thanks. This might work. I just have not figured out exactly how this translates to my query. I have one table and it has dates. like this:
1/03/2023
6/13/2023
6/30/2023
7/07/2023
I need to return a list of results showing the starting date (1/03/2023) and the ending date (7/07/2023) and a...
I need to see if there is a way in a query to list rows of date vales between a given starting and ending date. Specifically the issue is - I have a table that has records with date values in a field. If for example my first date is 7/1/23 and my last date is 10/3/23 - I want to return a list of...
I do understand that. This is however a very basic application. One table and one form. I can certainly create a form that opens, instead of the table. Just don't know if I am going to have the same issue. Will give it a try.