Import Data Via Csv Feed
I need to find a way to import a csv file into a sql database via classic asp or if easy .net to update a table. Every time this is imported i would like to overwrite the existing data in the database.
View Replies
ADVERTISEMENT
Data Feed
I have access to a .csv data feed behind a password-protected ftp server. What I would like to do is access the server via code, execute queries against the .csv data feed, and return live results.
Is there a way to do this?
Import Data From Cvs
nowdays im facing a real problem at work
i had finish my project but the remainig is only the import
can any body show me how i can import data from cvs file and store it in sql server 2000
i hope i get the answer as soon as posible
Interface For Import Data
i have a website and i use do import data , but with diffrent types(*.xls,*.xml...)
how can i concept a inteface to read all this files
i now my question is not clear but iit's freindly to answer me
Import Data From Adsi
I want to be able to import data from active directory using an asp page. The problem is that i don't want to provide any username or login, i want the system to identify the logged user.
the script is runing fine if i provide the username and the password in the script but when i delete them i receive this error messahe : Providererror '80040e37' - Table does not exist Code:
Import Txt Data In Table
I have a txt file and i would want to import many data fron txt and put in a table fo access...
For example
txt_var1 in table prova filed filed_var1
txt_var2 in table prova filed filed_var2
assuming my txt file is named test.txt and my mdb prova.mdb and table tabella1
Import The Textarea Data Into Database
I have searched a lot at GOOGLE, but i can't found the way to import data from a form textarea into database. Actually my web page would like to allow the user to export their phone book from excel file or outlook phone book, then import into my database.
I was thinking to provide a textarea for the user to COPY and PASTE their address book from the text file and then my web page will read line by line to store the data into the database.
Example data:
abc, abc@hotmail.com, 999999999
bcd, bcd@hotmail.com, 888888888
i can't find any solution that can read line by line, because normally when the we parse the data from the form textarea. All the text will become string that without the <br>.
How To Import The Textarea Data Into Database
I have searched a lot at GOOGLE, but i can't found the way to import data from a form textarea into database.
Actually my web page would like to allow the user to export their phone book from excel file or outlook phone book, then import into my database.
I was thinking to provide a textarea for the user to COPY and PASTE their address book from the text file and then my web page will read line by line to store the data into the database. Code:
Import Data From Excel File To Mdb Database Using Asp
I have excel file,from which the all data to store the .mdb database. Any one give an idea.
View Replies View RelatedData Feed Called By Javascript From Affiliate's Server
This is a mix of technologies so I hope I've put this in the right place.
I have a system where people can sign up to a data feed. They place a single line of Javascript on their web page and a formatted banner of products is displayed based on the options they have chosen in their affiliate account.
<script language="Javascript" src="http://www.somewhere.com/feed.asp"></script>
The original system was built by our developer 3 or 4 years ago, and worked fine. However, he built the system using two ASP files - feed.asp which looks like this:
Code:
RSS Feed
today a client asked me for an RSS feed on their website. I've never done it before. Bascially i've just spend a while on google and worming my way around the web but just cant seem to get my head around how the heck I make this thing work.
I basically want to embed an rss feed on a website in a little section that will act like a news bar. Can anyone describe to me in the simplest possible terms how i do it. Thats an rss feed, as part of a website. Not a descktop application or anything, it needs to be embedded.Im thinking its the morning tierdness thats making me 'not get it'
Rss Feed
I would like to create a RSS feed from my Access Database.
I have an Access table for news which has the article title, date, and
story in it. What I would like to do is pull the data from there into an
xml file to create the RSS feed, so when users upload a news story it
automatically updates in the xml file. Can this be done with asp? and where
should I look for more information.
What Is RSS Feed?
i am new to this RSS. so can any body tell me wat is RSS feed? wat is the benifit?
View Replies View RelatedRSS Feed
I have this statement which produces data from an RSS feed. The statement works well but I'm confused on how to format the {DC:DATE}.The date currently displays like this: 2006-05-22T08:57:00-04:00. I might like something else ie May 22, 2005 or maybe time.
This statement is inside ASP Tags.
ItemTemplate = " <a class='rssLink1' href=" & """{LINK}""" & ">{TITLE}</a> {DC:DATE}<BR>"
BBC RSS Feed
I want to put a BBC RSS Feed onto my site, and i dont want to link to a host, i want to link directly onto the bbc site.
View Replies View RelatedRSS Feed
where i can find a good explaination of RSS Feed and a example of it a working example of it. I searched google found some articles but it only tells me what RSS is an overview not in depth.
View Replies View RelatedRSS Feed
I am looking to set one up for the information on the following page (here ) in the "Forum - Recent Topics" box.
View Replies View RelatedRSS Feed - ASP
how to get news RSS feed in asp?
View Replies View RelatedDisplaying RSS Feed
Firstly, I am not a programmer, so forgive my complete and utter ignorance of all things ASP related.I am trying to display an RSS feed on a website using some ASP which I found on this website - http://www.tele-pro.co.uk/scripts/rs...d_class_dl.htm
I have downloaded the script and running it locally it works (kind of):-
However, when I put this page on my web server I get an error message:-
http://www.ubsigroup.com/testing/
The ASP file is here:-
http://www.ubsigroup.com/testing/rss...ed_class.1.txt
Create RSS Feed
how to create the RSS for a static ASP site. I have used CMS before which has buitin feature of creating the RSS. I like to write own RSS for individual pages. The site in question is SIPLNET.COM
View Replies View RelatedReading XML/RSS Feed With ASP
I could post the various bits of code that I've tried to use to get this to work... but it'd be kind of pointless as I haven't gotten very far with either of them (I've run across encoding problems, and problems where it works on the local machine, but not through ASP. I've tried using an XLT doc and without).
View Replies View RelatedParsing A CSV Feed
I need to create an asp page to parse a slightly unusual data stream which is in CSV format with new records identified by carriage returns. how to start? Really I want to just tabulate some of the data and ignore other fields. It's a travel industry data feed - sample record:
1,JNY,1,050718,1943,S,AHL,051217,LGW,ALC,0645,1235 ,051224,LGW,7,R,154,154,0,-1,0,8888,8888,,,WAL2,0,0,0,0,0,0,
RSS News Feed
Anyone know the code to retrieve and display an rss news feed ?
View Replies View RelatedRSS Feed To Email Via ASP
I would like to publish my RSS Feed to our blogger page via email. Can anyone direct me to an IIS-compatible solution so the blog could stay automatically updated? CDO would be the preferred mail component.
View Replies View RelatedRSS Feed Issue
i am trying to create my own rss feed.
I have got the xml to display in the browser. However, isn't an rss feed supposed to show the links and details in a list so when the user clicks on the link, it's supposed to go to that site? Code:
Making Rss Feed
if I make an rss feed from my site and put the address into IE, it just flashes and nothing happens. However, if I go to another browser, nothing much happens, but I can view the source and it's proper.
I then copy that source into a whatever.xml file and then upload it. Put that address into IE - and it looks like every other .xml file. The rss feed does validate as well.
So - here's my q: is there any way to get this to show in a friendly manner if clicked on? I'd like to just provide the link to the rss file on my site for people to use (without having to provide instruction of what's inside it).
CSV Import
I have scoured the web for everything related to CSV imports in ASP. I have everything working, but one issue remains.
My web application accepts a file upload of a Tab Delimited text file, parses through it to create a Comma Delimited file, creates that file on the server, and then goes to the CSV import page.
The CSV import page accesses the Comma Delimited file through ODBC text driver, and I generate SQL insert statements from each record. The problem is, one field is a "room number" field which generally contains numbers, but several entries also contain letters, an entry might be "A121" or "AUD" or "254", etc.
I'm guessing that ASP or the ODBC text driver "guesses" the datatype of the field, because whenever it hits a record with letters in the "room number" field, it uses the last numeric value for that field from any previous record. If there are multiple records with letters in this field, it will continually show the most recent numeric entry from that field, even if it was 5 or 10 records ago!
I am accessing these values using recordset("fieldname"), and all other fields display correctly, except recordset("roomnumber") when there are letters and numbers in the entry.
I've opened the CSV directly on the server and the fields are all fine, in the "room numbers" field, the entries which are all numbers are right-aligned, while entries with numbers and letters are left-aligned, but I assume that's just the way Excel displays them.
I am aware that adding quotation marks around this field would solve the problem, but there is no way I can have the data format changed. I might try to add quotations while creating the CSV file on the server, but this is such a strange problem that I'd like to figure it out anyways.
Import Txt
I still have problem to import the text file delimited by tabs or commas into the database.
I refer to http://www.connectionstrings.com/ for the connection, ODBC doesn't work and OLD DB works only for csv files. Any idea? Does anybody has workable samples?
Standard:
"Driver={Microsoft Text Driver (*.txt;
*.csv)};Dbq=c: xtFilesFolder;Extensions=asc,csv, tab,txt;"
OLE DB
Standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c: xtFilesFolder;Extended
Properties=""text;HDR=Yes;FMT=Delimited"""
Read XML Feed From Yahoo In ASP
I have been struggling with this for ages and have seen nothing but brick walls! This is what I'm trying to do:
1. Read the information from this Yahoo weather feed:
ptth//:xml.weather.yahoo.com/forecastrss?p=AUXX0040&u=c
(i changed the http etc as it wouldn't let me post the link)
2. Pluck out selected info like weather status and temperature etc and display it using my own formatted text/icons on my website.
It seems so simple, I just cannot get it to work. Please can anyone help me with the parsing function? and then how to display the info?
How I Include RSS Feed Into My Website
How I include RSS feed into my website using ASP?
View Replies View RelatedImport RTF Content
how to import the rtf format content to word file.
View Replies View RelatedImport Objects In Asp?
I have a problem with including an object in my asp page. I�ve translated an algoritm I found that was written in javascript and it needs a method, floor(), from System.Math to work.
in javascript you can just write Math.floor(x+1) but it seems asp doesn�t automatically include that Math object. It�s a little weird since the method Round() can be used withour any includes of any kind and thats a part of the Math object!
So... How do I do to access this floor() method?
I tried to write:
<%Imports System.Math %>
but it doesn�t seem to do the trick.
Import Pages
I have a main page called you.asp .In this asp page there is a question What is your gender ? followed with 2 Radio buttons Female and Male.When I select the option Female I want to import QESTF.asp to the main page which is you.asp and when I select the option Male , it should import QESTM.asp to the main page. QESTF.asp and QESTM.asp has only a greeting message. How can I do it ?
View Replies View Related