Search results

  1. W

    How to export data structures from MS Access 2000

    Anyone knows how to export data structures from MS Access 2000? I want to export field name, field type, field size, remarks from the structure. No records are required! Does it possible? Please help! Wilson
  2. W

    INSERT and SELECT statement problem

    Can I insert record from the SELECT statement as below: INSERT INTO Table1(Field1, Field2) SELECT B.Field1, Count(B.Field1) FROM Table2 B WHERE (B.Field2 BETWEEN #01/01/2003# AND #25/01/2003#) GROUP BY B.Field1; I have tried in MS Access 2000, it gave me error. It said data type conversion...
  3. W

    How to get row number in SQL

    Hi, Anyone knows how to get the row number in Microsoft Access 2000? In ORACLE, we can do like this: SELECT ROWNUM, Field1, Field2, Field3 FROM Table1; How do I write SQL statement in MS Access 2000? Thanks. Wilson :D
  4. W

    How to get Row Number in MS Access 2000?

    Hi, Anyone knows how to get the row number in Microsoft Access 2000? In ORACLE, we can do like this: SELECT ROWNUM, Field1, Field2, Field3 FROM Table1; How do I write SQL statement in MS Access 2000? Thanks. Wilson
Back
Top Bottom