Hello everybody,
for my current project I need to import a .WRI-file using "DoCmd.TransferSpreadsheet".
The file itself is plain text and created by an external software so there is no way I can change the format.
Up to now I manually imported the file into Excel and then imported that file into Access using the mentioned method.
Is it possible to
a) directly import the .WRI-file into Access or
b) create a makro that would automatically import the .WRI-file into Excel and then Access afterwards?