dbTalk Databases Forums  

import a CSV file w/ First row of data as field names by program not interactive way

comp.databases.paradox comp.databases.paradox


Discuss import a CSV file w/ First row of data as field names by program not interactive way in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Carl
 
Posts: n/a

Default import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 08:55 AM






I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox Dos
cannot import directly data such as First row of data as field names. I have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?



Reply With Quote
  #2  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM






Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #3  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #4  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #5  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #6  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #7  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #8  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:03 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
of course it can.. open the file in the mini-editor and delete the first
line.. then import the file..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #9  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:06 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
or, if your pdoxdos issue is the field names.. import the file, and pass the
first record to an array, then delete the first record.. then use the
restruct screen to change the field names..

in other words, you can do anything you want, directly within pdoxdos.. all
you need, is to know how.. (g)

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
  #10  
Old   
Steven Green
 
Posts: n/a

Default Re: import a CSV file w/ First row of data as field names by program not interactive way - 07-23-2008 , 09:06 AM



Quote:
Pdox Dos cannot import directly data such as First row of data as field
names.
or, if your pdoxdos issue is the field names.. import the file, and pass the
first record to an array, then delete the first record.. then use the
restruct screen to change the field names..

in other words, you can do anything you want, directly within pdoxdos.. all
you need, is to know how.. (g)

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Carl" <carlogawa (AT) verizon (DOT) net> wrote

Quote:
I need to import a CSV comma delimited file which has First row of data as
field names by program not interactive way.

Pdox Win (v. 11) INTERACTIVE import has the check mark box for First row
of
data as field names.

Unfortunately ObjectPAL importASCIIVar or appendASCIIVar does not have
this
optional parameter for this. Is there any work around?

Actually I need to integrate to existing pdox dos (v 4.0) program. Pdox
Dos
cannot import directly data such as First row of data as field names. I
have
to launch Pdox Win or other software from Dos program to import CSV data.
Does anyone know such conversion software which masks interactive import?





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.