Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel to DBF - quickly
Message
 
To
12/05/2001 07:21:18
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Excel to DBF - quickly
Miscellaneous
Thread ID:
00506263
Message ID:
00506626
Views:
17
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.
    • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform