Have you tried to import the data into Access using File | Get External Data
| Import from the menu?

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
>i have 5000 records in Ms-Excel and iam interested to import in MS-Access
>pls
> help