I was doing some research about patents and Microsoft has registered this: "Drop down menus provided by a computer program are provided in two states, a short menu state and a long menu state. When a user opens a desired menu, the menu opened will initially take the form of a short menu of executable commands which are a subset of the total number of executable commands available under the selected menu. The short menu may be dynamically expanded into a long menu which will contain the complete set of executable commands available under the selected menu. The short menu may be adapted to the personal needs of the user when the user selects commands from the long menu which are not contained in the short menu. Usage information is stored and updated on the usage of each menu command added to a short menu. Menu commands are removed from the adapted short menus based on non-use of those menu commands by the user. Information stored, maintained, and updated on the usage of the menu commands added to the short menus is stored in a compact and efficient data structure which facilitates efficient computer memory use." Is there any copyright expert here? Did I get that right? If I develop a control that imitates a cool Windows or Office feature I'll probably have to license its "intellectual property" first? Come on, I'm not talking about a big GUI revolution - just a cool menu... :-) wm

Hi Steve, This is not the best code I've ever wrote, but I hope it can help you. :-) Assuming that the first line is always the table name, you could do something like this: --struct.txt CustomerName CustID, INTEGER FirstName, STRING --code CStdioFile f; CString sLine, sSql; int nLine = 0; sSql = "CREATE TABLE "; f.Open("struct.txt", CFile::modeRead); while (f.ReadString(sLine)) { if (sLine.GetLength()) { if (++nLine == 1) { sSql += sLine+'('; } else { sLine.Replace(",", ""); sSql += sLine+','; } } } sSql.SetAt(sSql.GetLength()-1, ')'); f.Close(); AfxMessageBox(sSql); Regards, Wanderley