Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import from Quickbooks
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00233427
Message ID:
00234052
Views:
31
>I haven't tried anything with the QB files -- don't have any experience with other data formats. If you have any suggestions, let me know.
>
>thanks again,
>Doug

Doug --

You might want to try experimenting with test copies of the QB files. First, try opening one of the files with a text editor (NotePad, TextPad, etc.). Then, if you can decipher the file format from what you see in the text editor, you've got a couple of options for getting the data into VFP:

1. This is a long shot, but if the QB file looks like it might be some flavor of a .DBF (dBASE, Clipper, etc.), you can probably deal with it as a "free" table in VFP. You might have trouble, though, if there are any memo fields. NOTE: If you look at a .DBF with a text editor, it will have a header followed by any number of data records with fixed-lenth fields.

OR

2. If the QB file appears to have fixed-length fields, you could create a Fox table (or cursor) with matching fields/types/lengths, and then use APPEND FROM...TYPE SDF to import the QB data.

OR

3. You might be able to use low-level file-handling functions (FREAD or FGETS) to read the QB file.

If none of the above suggestions work, then you might want to call the QB vendor.

Bill
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform