Field Mapping Sample - CSV to Sql Serverusing asp or VB

Does anyone have an example of field mapping?


I am trying to write an app that reads a .csv file and then allows a
user to map those .csv fields to existing SQL fields...


I have the reading of the .csv & writing to SQL, but hit the wall trying
to get a mapping process to work...


Ideally, I would check off a field from the csv and check off a
corresponding field in the sql field then hit a map button and it would
set the fields in the sql statement according - also removing those two
selections.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.706 / Virus Database: 462 - Release Date: 06/14/2004

re: Field Mapping Sample - CSV to Sql Serverusing asp or VB

"Ashish Kanoongo" <ashishk@armour.com> wrote in message
news:ujHg4CDVEHA.2408@tk2msftngp13.phx.gbl...

[color=blue]
> I am trying to write an app that reads a .csv file and then allows a
> user to map those .csv fields to existing SQL fields...[/color]

A Web app? If so, there's no point asking in the *.vb.* groups. Try
microsoft.public.scripting.vbscript.

re: Field Mapping Sample - CSV to Sql Serverusing asp or VB

I am looking for both type of option vb as well as in asp.

"Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
news:%23ZQQxiGVEHA.2992@TK2MSFTNGP12.phx.gbl...[color=blue]
>
> "Ashish Kanoongo" <ashishk@armour.com> wrote in message
> news:ujHg4CDVEHA.2408@tk2msftngp13.phx.gbl...
>
>[color=green]
> > I am trying to write an app that reads a .csv file and then allows a
> > user to map those .csv fields to existing SQL fields...[/color]
>
> A Web app? If so, there's no point asking in the *.vb.* groups. Try
> microsoft.public.scripting.vbscript.
>
>[/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.707 / Virus Database: 463 - Release Date: 06/15/2004

re: Field Mapping Sample - CSV to Sql Serverusing asp or VB

Hey Beeeeeeeeeeeeves,

I like the new alias!

--
Al Reid

"It ain't what you don't know that gets you into trouble. It's what you know
for sure that just ain't so." --- Mark Twain

"Beeeeeeeeeeeeves" <Beeeeeeeeeeeeves@discussions.microsoft.com> wrote in message
news:B8873FD5-E64E-4F21-8608-F3322FF880B2@microsoft.com...[color=blue]
> Tip - if you're writing a web app but want help from the VB guys, claim to be using webclasses.
>
> "Ashish Kanoongo" wrote:
>[color=green]
> > I am looking for both type of option vb as well as in asp.
> >
> > "Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
> > news:%23ZQQxiGVEHA.2992@TK2MSFTNGP12.phx.gbl...[color=darkred]
> > >
> > > "Ashish Kanoongo" <ashishk@armour.com> wrote in message
> > > news:ujHg4CDVEHA.2408@tk2msftngp13.phx.gbl...
> > >
> > >
> > > > I am trying to write an app that reads a .csv file and then allows a
> > > > user to map those .csv fields to existing SQL fields...
> > >
> > > A Web app? If so, there's no point asking in the *.vb.* groups. Try
> > > microsoft.public.scripting.vbscript.
> > >
> > >[/color]
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.707 / Virus Database: 463 - Release Date: 06/15/2004
> >
> >
> >[/color][/color]

re: Field Mapping Sample - CSV to Sql Serverusing asp or VB

Let froget web application, suggest some thing on client server base
application.
"Beeeeeeeeeeeeves" <Beeeeeeeeeeeeves@discussions.microsoft.com> wrote in
message news:B8873FD5-E64E-4F21-8608-F3322FF880B2@microsoft.com...[color=blue]
> Tip - if you're writing a web app but want help from the VB guys, claim to[/color]
be using webclasses.[color=blue]
>
> "Ashish Kanoongo" wrote:
>[color=green]
> > I am looking for both type of option vb as well as in asp.
> >
> > "Jeff Johnson [MVP: VB]" <i.get@enough.spam> wrote in message
> > news:%23ZQQxiGVEHA.2992@TK2MSFTNGP12.phx.gbl...[color=darkred]
> > >
> > > "Ashish Kanoongo" <ashishk@armour.com> wrote in message
> > > news:ujHg4CDVEHA.2408@tk2msftngp13.phx.gbl...
> > >
> > >
> > > > I am trying to write an app that reads a .csv file and then allows a
> > > > user to map those .csv fields to existing SQL fields...
> > >
> > > A Web app? If so, there's no point asking in the *.vb.* groups. Try
> > > microsoft.public.scripting.vbscript.
> > >
> > >[/color]
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.707 / Virus Database: 463 - Release Date: 06/15/2004
> >
> >
> >[/color][/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.707 / Virus Database: 463 - Release Date: 06/15/2004