Good morning all,
I am having an extremely difficult time importing the attached worksheet into Access. I have renamed and reformatted all cells, but to no avail. Any guidance would be greatly appreciated
Results 1 to 5 of 5
-
3 Star Lounger
- Join Date
- Dec 2000
- Location
- Columbus, Ohio, USA
- Posts
- 286
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2007-06-14 11:59Import Excel Sheet (Access 2K/XP)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
3 Star Lounger
- Join Date
- Dec 2000
- Location
- Columbus, Ohio, USA
- Posts
- 286
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2007-06-14 12:24Re: Import Excel Sheet (Access 2K/XP)
I converted the spreadsheet to .txt, tab delimited and was able to import. Hope this helps someone else.
-
4 Star Lounger
- Join Date
- Jan 2003
- Location
- Central Florida, USA
- Posts
- 505
- Thanks
- 5
- Thanked 0 Times in 0 Posts
2007-06-14 16:14Re: Import Excel Sheet (Access 2K/XP)
There appears to be something wrong with the header row. I renamed each of the column headings, then saved it and it imported fine into Access 2k and 2003.
-
2 Star Lounger
- Join Date
- May 2001
- Location
- Omaha, NE USA, Nebraska, USA
- Posts
- 119
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2007-06-14 18:24Re: Import Excel Sheet (Access 2K/XP)
Cell E1 had a space before the word Status that was causing the import issue.
-
3 Star Lounger
- Join Date
- Dec 2000
- Location
- Columbus, Ohio, USA
- Posts
- 286
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2007-06-14 18:58Re: Import Excel Sheet (Access 2K/XP)
Thanks to both of you for your replies. I knew something was awry but couldn't see the forest for the trees. Probably explains why the .txt imported. Thanks again.
