Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Conversion from XL to ACCESS (Office97 SR2)

    I have 5 XL files that I want to convert to Access databases. The filenames are as follows: ansfeb.xls, ansJune.xls, ansaug.xls, ansSept.xls, and ansjuly.xls. So, while in the ansfeb.xls file, I click on DATA and then "Convert to MSACCESS and it works like a charm. I then enter the second file, ansJune.xls, and follow the same steps but this time I get a different screen (see attachment) that thinks I am trying to convert a Lotus file to EXCEL and, while I am able to convince it that the source file is XL and not Lotus, I can not convince it to convert to Access. Instead, it converts to an XL copy of the same file. I have tried moving the first database to another location, no luck. Finally, I shut down excel and re-opened it. Lo and behold, the conversion worked on the 2nd file. I had to do this for each file. Whats this all about? I used to think that EXCEL was top of the line. All these little bugs are getting tiresome.
    Anyone who knows what is happening I would be pleased to listen, rather read about it. If not, I will just chalk it up as another worthless experience.
    Thanks
    Stephen <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Conversion from XL to ACCESS (Office97 SR2)

    Can't explain what is happening with Excel, but anytime I needed to take information from Excel to Access, I start in Access and do a File | Get External Data | Import. This brings up a dialog box so you can navigate to your file (make sure to change the "Files of Type" box to Microsoft Excel).

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Conversion from XL to ACCESS (Office97 SR2)

    Excel may be "top of the line" (not that there are too many other competitors) but it definitely isn't bug free. No program worth using is bug free. I'm happy you found a suitable workaround as often times you can't. I've found quite a few undocumented features in Excel VBA but so far have always found a workaround (not without much profanity though). It's always quicker to figure out a workaround on your own than wait for any fix from the manufacturer.

    Deb <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •