Webdude,
Since you are using MS SQL, have a look at BCP.exe, which is a MS db
utility specifically designed for bulk imports/exports with MS SQL.
Calling BCP via a batch file is the fastest way for Witango to get
data into or out of MS SQL.
Regards,
Jason.
On 29/11/2007, at 5:39 AM, Web
well, if its a tab delimited file, you have to read it in, and turn it
into an array, or something like that for witango to be able to then
insert the values into a db.
CSV can be challenging, if you have to deal with quoted values and
such, the easiest is some type of delimited file, that
Don't mean to ask dumb questions, but what do you mean by parse the file?
_
From: Robert Garcia [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 28, 2007 12:53 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Upload then Import
Sure, you just do an upload form, parse the
Sure, you just do an upload form, parse the file, and insert/update.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/
Witango 2000
MSSQL 7
W2k Server
I there a way or routine to upload a file (csv, tab delimited, xsl or
whatever) and then import into an existing table? I am hoping for a Witango
solution. Anyone ever do something like this?
Thanks!
__
