you can use ADO to connect directly to the db and pull in the data via CopyFromRecordset.
or
use data tab, Get External data, From text, (to import CSV)
or
parse xml code to get web data