Importing Data From One That Is In An Access Database To Sql 2005

I hope I am giving the right information here to get help with this.

I am trying to get information from two tables that are in an access database over to sql 2005. I did this via dts and saved the import options as a file, but when I run this as a job I get the following error: Date 2/27/2008 11:14:08 AM
Log Job History (CombinationTable1)
Step ID 0
Server D86J0PD1
Job Name CombinationTable1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job failed. The Job was invoked by User BIZCHAIRDarleneMurphy. The last step to run was step 1 (CombinationTable1).

I have also tried to run this in the following way:



USE Combination_Table

CREATE TABLE GG Products

AS

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'W:MASTER DOCUMENTSDatabasesChannel_Advisor_Feed.mdb';'admin';'', GG Products)

go


Here I get errors regarding nulls and if I pointed to the correct database, which I have.

Any help with this problem and I hope I have given good information in order to get help.

Thank you
Dee