Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel to DBF - quickly
Message
 
À
12/05/2001 07:21:18
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Excel to DBF - quickly
Divers
Thread ID:
00506263
Message ID:
00506626
Vues:
18
Hi Cetin,

The following worked for me:

  • make sure that the excel sheet has column headings in the first row
  • create a DSN based on the XL ODBC driver and pointing to the xls file
  • create a new connection based on the DSN
  • create a new remote view and choose to show the system tables
  • use Sheet1$ as the source table
  • choose the fileds you want to include as usual
  • set the properties of each field in the view as required
  • run the view

    I'm running XL2K and Win2K, Excel ODBC Driver v4.00.5303.1

    Cheers,

    Andrew

    >>Another useful way to do this is to set up an ODBC data source that points to the Excel Sheet and then get a remote view of the sheet. You can set the column types to be anything you like in the view properties and then USE the view and COPY TO a DBF.
    >>
    >>Cheers,
    >>
    >>Andrew
    >>
    >Hi Andrew,
    >Honestly I never was able to connect to a regular excel file. Could you give a sample. TIA.
    >Cetin

    If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?

    From Top 22 Developer Responses to defects in Software
    2. "It’s not a bug, it’s a feature."
    1. "I thought I fixed that."

    All my FoxTalk and other articles are available on my web site.

    Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
    • Précédent
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform