|
| | | Junior Member
 
Group: Forum Members
Last Login: 9/4/2009 11:36:00 PM
Posts: 13, Visits: 11 |
| | |
| | | Forum Member
Group: Forum Members
Last Login: 6/5/2009 7:26:52 AM
Posts: 45, Visits: 34 |
| If you use COPY TO ... TYPE XL5, or, alternatively, COPY TO ... TYPE FOX2X (that will copy into an older format DBF file which you can open from Excel and save as XLS), it recognizes numbers and dates just fine.
_________________________________________________
tradeshow giveaways
adverse credit remortgage uk
|
| |
| | | Junior Member
Group: Forum Members
Last Login: 9/4/2009 11:36:00 PM
Posts: 13, Visits: 11 |
| | |
| | | Forum Member
Group: Forum Members
Last Login: 6/5/2009 7:26:52 AM
Posts: 45, Visits: 34 |
| | |
| | | Forum Newbie
Group: Forum Members
Last Login: 1/30/2010 3:04:41 AM
Posts: 7, Visits: 7 |
| I have been given the task of converting a program from VFP (visual
foxpro) to Visual Basic.net. My question is "Is it possible to
generate a DBF file Dynamically(at runtime) using Visual Basic.Net?"
With all the field properties, such as, field length and type. I'm not
sure if this is a stupid quesiton or If I am just over looking
something, but I have not found solid information on the internet
about this topic.
>
Any useful information would greatly be appreciated.
>
Further Information:
1. The program I am coding, opens up various types of data (.txt,
.xls, .dbf) and processes the data files and then exports as a .dbf
file.
2. The program also opens existing dbf files, searches for companies,
and the then alters the dbf file and also creates a new dbf with just
company names.
>
Since the primary postal software that we use only supports dbf files,
I need to generate dbf files. (note: all the data files I am working
with do not have the same pattern, they come in different structures
(different data columns))
>
I have been pondering on a few things about this topic but am seeking
professional advise before I start programming.
=========
Promotional Gifts
3M Furnace Filters
Sekar |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 3/1/2010 6:53:04 AM
Posts: 3, Visits: 2 |
| The DBF file's will not be FoxPro files, Basically what I will be doing
is converting text file, excel files, CSV files, to DBF files, such as,
What microsoft does when you export a table/query from microsoft
access, and save as a "DBF".
I don't have a problem connecting to a dbf file and creating a dataset
with the file information, but, I do forsee a problem (which I have not
yet began to code) updating or creating a new dbf file. If this is as
easy as generating a xml, txt, excel from visual studio, than this
should not be a problem. One thing I do question is the .cdx file that
is associated with the dbf file. Is this .cdx file required or is this
..cdx file something that vfp has generated. Please keep in mind the
program that I am writing in visual studio will be replacing vfp
program.
a few program details:
The program I am creating imports various data types into
datasets/tables, then processes ithe nformation within the
dataset/tables, then exports as a dbf file. Such as, the way microsoft
access does when you import various file types, and then export as a
dbf file. The only difference is my program has data intelligence that
will determine the length and data type for each column then add a few
columns if needed. This should reduce mistakes, and reduce processing
time.
Another task, is opening a dbf file (an existing dbf file), filter
through each record and seperate residents from companies. Some of our
clients do not want to mail information to companies, so I set up an
xml file with various key words which will be used as filters, I want
to alter the existing dbf file (pull out company names or if needed
create a new dbf file) and I also want to create a new dbf file with
just company names.
============
contemporary furniture
wine sales
DDNI |
| |
|
|