Excel 07 Visual Basic import to Access 07

I have a DBA that i created, it imports some excel files with specific formating (a colum is formated with custom “0000000”) when i run my code it drops the fromatting when it is imported to the DBA. when i do a manual import to a new table it will keep the formating. if you need code let me know and i will post. any help would be great.