SQL statement to take a string value after FROM??

[Aoife]

How can I get the following SQL statement to take a string value after FROM. SqlString = "SELECT * " "FROM ?????"; The string name is strFolderOpen and this will hold the name of the Access database to open. Thanks, Aoife

[l a u r e n]

assuming SqlString is a CString: SqlString.Format("SELECT * FROM %s",strFolderOpen); or have i misunderstood the question? --- "all's fair in love and war but in love there's no geneva convention"

[Aoife]

Thanks a million Lauren, it works perfectly!!:-D