Hi,
I have a table in msaccess with the following data
Table1
IDDatabase
ID-1ABC^DB-1^MSSQL^PROD
ID-1XYZ^DB-2^MSSQL^PROD
ID-1DEF^DB-3^MSSQL^PROD
ID-1GHI^DB-4^MSSQL^PROD
ID-2HJIID-2POKILID-2YGTF
ID-2CCML
ID-3HYTD^DB-5^ORACLE^PROD
I am trying to split the data in database column in a new...