I just tried it using your first option in Office 2003. I formatted the cells in Excel as 'Text'. I then created a new database and imported the Excel worksheet (File->Get External Data->Import). The only change I made was to untick 'First row contains column headings'. It worked! What version of Office do you have?