Import of a .WRI-file

[rndmxy2k13]

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?

[ItsMe]

Make a copy of the file and save it locally.

Change your folder settings on your PC to view "Known File Extensions"

On your copied file's name, change the extension to .txt

Open your file.

If it opens using your text editor (Notepad) then study the format. Is it fixed width or delimited? Are there commas or large spaces between fields?

If all of this looks good so far then, you need to have your computer automate a file save as and convert your file to .txt. Command line can accomplish this and there are ways via VBA.

Once you have the file type you need you can use the wizard to import and save the macro to be called later in VBA