Trouble Using SQL Database In VB Express

First off, I am fairly new to sql.



I've created an sql database in VB express, created some tables, and entered some data in those tables. My problem now lies with actually using that data. What i'd like to do is have a Sub use the database's data and fill in a series of variables. Right now i have the Sub using an Excel file to assign the information, looks like this:



Public Sub CharStatDefault() 'loads each character's default stats

CharSheet = xlBook.Worksheets(2)



P.initialize()



For excelInt = 1 To 22

P.C(excelInt).Initialize()

With P.C(excelInt)



.Vit = CharSheet.Range("AC" & excelInt).Value

.Phy = CharSheet.Range("AD" & excelInt).Value

.Mag = CharSheet.Range("AE" & excelInt).Value

.Off = CharSheet.Range("AF" & excelInt).Value

.Def = CharSheet.Range("AG" & excelInt).Value

.Agl = CharSheet.Range("AH" & excelInt).Value



End Sub



So basically i want to change the CharSheet.Range("XX" & excelInt).Value to something that utilizes the data from my database.