Bonjour,

J’ai besoin d’aide afin de corriger mon importation dans Sage 50.

J’ai créé une requête Power Query pour obtenir toutes les informations requises pour un fichier d’importation (.IMP). Ensuite, j’ai développé une macro afin de générer automatiquement un fichier .IMP prêt à être importé dans Sage 50.

Cependant, lorsque je lance l’importation (en double-cliquant sur le fichier), le processus débute avec le nom du client, puis une erreur s’affiche : « date invalide à la ligne 1 ».

J’ai passé beaucoup de temps à tester différentes solutions proposées sur les forums, mais sans succès.

Voici un extrait du fichier TXT que j’essaie d’importer :

Merci à l’avance pour votre aide,

<Version>

"12001", "1"
</Version>
<SalInvoice>
"SMM"
"2","99999999","4-30-2026",0,"54650,74","0.00"
"122","54,0000","59,5000","3213,00","160,64","320,50","G","0","1","5,00","8,93","Q","0","1","9,98","17,81"
"128","41,0000","54,3000","2226,30","111,29","222,10","G","0","1","5,00","8,14","Q","0","1","9,98","16,25"
"095","78,7500","82,1000","6465,40","323,29","644,93","G","0","1","5,00","16,42","Q","0","1","9,98","32,76"
"107","85,2500","56,3000","4799,58","239,96","478,76","G","0","1","5,00","5,63","Q","0","1","9,98","11,23"
"103","23,5000","55,2000","1297,20","64,86","129,38","G","0","1","5,00","2,76","Q","0","1","9,98","5,51"
"096","91,0000","65,7000","5978,70","299,00","596,38","G","0","1","5,00","23,00","Q","0","1","9,98","45,87"
"131","11,5000","141,2000","1623,80","81,16","161,95","G","0","1","5,00","28,24","Q","0","1","9,98","56,34"
"082","23,0000","59,2000","1361,60","68,08","135,82","G","0","1","5,00","5,92","Q","0","1","9,98","11,81"
"037","89,5000","182,0000","16289,00","814,49","1624,83","G","0","1","5,00","54,60","Q","0","1","9,98","108,93"
"901","1,2500","102,1000","127,63","6,38","12,73","G","0","1","5,00","5,10","Q","0","1","9,98","10,18"
"045","10,0000","65,4000","654,00","32,67","65,22","G","0","1","5,00","0,82","Q","0","1","9,98","1,63"
"003","2,7500","66,7000","183,44","9,17","18,30","G","0","1","5,00","0,83","Q","0","1","9,98","1,66"
"011","4,7500","125,5000","596,13","29,81","59,47","G","0","1","5,00","6,27","Q","0","1","9,98","12,52"
"052","12,5000","143,9000","1798,75","89,93","179,42","G","0","1","5,00","7,19","Q","0","1","9,98","14,35"
"071","4,7500","116,0000","551,00","27,55","54,97","G","0","1","5,00","5,80","Q","0","1","9,98","11,57"
"028","4,7500","77,3000","367,18","18,36","36,63","G","0","1","5,00","18,36","Q","0","1","9,98","36,63"
</SalInvoice>