DIXF setup notes

File name

That was a bad idea to name an entity with characters forbidden by Windows for filenames...

​

It raises an error while trying to Generate source file.

 Excel version

To work well with Excel we need to have ODBC Excel 64 bit driver installed on the server

http://www.microsoft.com/en-us/download/details.aspx?id=13255

cmd (as administrator)

AccessDatabaseEngine_x64 /passive

Excel sheet name

And not to forget to add $ at the end of lookup sheet name.

Yes, $$$ rule as usual…