Direct import of Excel spreadsheet into Access (1 Viewer)

[CNorway]

Hi,


I get a daily Excel status report.


The header in this report includes a "." dot.



I want to import this data into Access each day.


What is the best way of doing this?


(I posted a different post on pasting it directly, but see that having to replace the "." manually each day in Excel is probably still not an optimal solution).



Thanks!
Chris

 

[Galaxiom]

You could edit the Excel file from Access using automation.

 

[Gasman]

Don't import the headers?

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.transferspreadsheet

 

[CNorway]

You could edit the Excel file from Access using automation.

OK, I took a look at this and was a bit too complicated for me. Though, I did just discover that I can have access link to the excel file itself and then have it append the data to another table just fine without having to worry about the header row. Thanks.

 

[CNorway]

Don't import the headers?

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.transferspreadsheet

Hi,


Yes, that would also simplify it. Though, I have now found an optimal solution after looking around quite a bit. I can simply link access to the Excel file directly. Then, each day, I just put the latest status report into the folder and let Access append the data into the SQL Server table from there. Thanks.