It's been a while, but Amtrak used to offer transfers to SF via bus. They have several stops in SF and I believe the Moscone Center is one of them. There are several hotels in the area, the Marriott being one of the largest. It's only a couple of blocks to the nearest BART station or to the cable car stop.