SELECT ID, 1 AS Seq, Left([fieldname],2) AS DrawNumber FROM tablename
UNION SELECT ID, 2, Mid([fieldname],4,2) FROM tablename
UNION SELECT ID, 3, Mid([fieldname],7,2) FROM tablename
UNION SELECT ID, 4, Mid([fieldname],10,2) FROM tablename
UNION SELECT ID, 5, Mid([fieldname],13,2) FROM tablename
UNION SELECT ID, 6, Mid([fieldname],16,2) FROM tablename
UNION SELECT ID, 7, Mid([fieldname],19,2) FROM tablename
UNION SELECT ID, 8, Mid([fieldname],22,2) FROM tablename
UNION SELECT ID, 9, Mid([fieldname],25,2) FROM tablename
UNION SELECT ID, 10, Mid([fieldname],28,2) FROM tablename
UNION SELECT ID, 11, Mid([fieldname],31,2) FROM tablename
UNION SELECT ID, 12, Right([fieldname],2) FROM tablename;