Excel 2000 to Access 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Trish (anonymous_at_discussions.microsoft.com)
Date: 03/17/04 

Date: Tue, 16 Mar 2004 21:56:07 -0800

I have received data in an Excel spread*** that I wish to import into Access 2000. The data in the spread***, unfortunately, has the columns at the side and the details across the page, which means that the headings are constantly repeated, eg:

Name: Jo Bloggs
Company: Jo Bloggs & Co
City: New York
Name: Sue Smith
Company: Sue Smith’s boutique
City: Los Angeles
Name: John Brown
Company: John Brown Seafood Delights
City: Washington

How can I bring this into Access properly? Grateful for any suggestions.

Quantcast