I'm attaching to an Access 2000 database on a shared mapped drive and can pull 1 column in at a time through my SQL statement. I have to execute a separate SQL call for each column, which seems to be a waste. I want to be able to pull in and show all the fields in each row. What do I do to show both / all of the columns in each row?
(I'm just trying to get a handle on this, so I know this application doesn't make sense yet....) Thanks in Advance! [ February 18, 2004: Message edited by: Sam Smoot ]
This could be your problem, unless SQL Server allows this! String SQL="SELECT FirstName LastName FROM TeamInfo"; the missing comma between FirstName and LastName. Try changing it to String SQL="SELECT FirstName, LastName FROM TeamInfo";