Import Function!

Posted on 2006-04-11
Last Modified: 2010-04-17
Hi all this is Sam.

I'm a Visual Foxpro 6.0 user and now having troubles of using import function.

I'm expecting to import .rep format file content into Visual Foxpro Database(VFPDB). I checked out the reference bood and VFP doesn't seem understand this format, then I used Excel to open this file and its data were mixed up in one column. I used wizard what gererated by Excel to put them all back in right columns, and now its able to be imported into VFPDB.
But imagine how long would it take if over 300 .rep files to be imported?
So is there any other way out to do that without through Excel?

Urgent and many thanks,
Question by:sami_hung
    LVL 33

    Accepted Solution

    Can you tell us what a .rep file is?
    LVL 33

    Expert Comment

    And it might be better to post your Foxpro questions in the EE Foxpro area:
    LVL 33

    Expert Comment

    If it is a columnar text file, you could use APPEND FROM:

    APPEND FROM Command

    APPEND FROM FileName | ?[FIELDS FieldList] [FOR lExpression]
          | WITH CHARACTER Delimiter] | DIF | FW2 | MOD | PDOX | RPD |
          SDF | SYLK | WK1 | WK3 | WKS | WR1 | WRK | CSV | XLS | XL5
          [SHEET cSheetName] | XL8 [SHEET cSheetName]]] [AS nCodePage]

    APPEND FROM myfile.rep TYPE SDF

    But, I have no idea what a .rep file is.

    Author Comment

    Well .rep is the format where gererated by the computer machine, but not sure what machine is. It seemed no way to import .rep into Visual Foxpro, as VFP doesn't contain such format. But thanks for your comments.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I know it’s not a new topic to discuss and it has lots of online contents already available over the net. But Then I thought it would be useful to this site’s visitors and can have online repository on vim most commonly used commands. This post h…
    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now