Importing ACT! And Outlook Addresses
We need to import the contact details from Act! and Outlook/Outlook Express
(Both) to a website (hosted database MSSQL or Access). Is that possible in
any ASP Scripting?
We need to import the contact details from Act! and Outlook/Outlook Express
(Both) to a website (hosted database MSSQL or Access). Is that possible in
any ASP Scripting?
I'm importing from a csv file but got the following error :
If theres a newline field in one of the columns (i.e with a text field) and I want to read that line from code it see everything after the new line as a new line.
If I open the file in notepadeverything's on one line as it should be, but somehow the importing mess it up.
I am having a problem displaying data into an ASP Listbox , when I import data in random named field names say 1, 3, 5 from SQL
empty records of hypthytical 2,4 are shown inti ASP listbox
I can't find the code to display the client IP address on
the client browser. Shouldn't it be 'session. '?
I found some strange IP addresses from my sitemeter, like these :
61.64.190.183, 10.100.4.114
unknown
unknown, 220.133.93.18
105.200.35.170, unknown
They are retrieved by Request.ServerVariables("HTTP_X_FORWARDED_FOR") and
Request.ServerVariables("REMOTE_ADDR") in asp page.
what are they ?
I've got a csv file which I will need to import into an access db via asp.
The csv file will be imported every day of each month so there will be
duplicates which will not need to be imported.
Can anyone tell me how to exactly import excel sheets into sqlserver from the dts?
View Replies View RelatedI'm trying to import my outlook contacts into my access database using a .csv file. i want to be able to browse for the .csv file and hit an upload button on my site and be able to see them all.
View Replies View RelatedIs there a way of importing information from an Excel document or a comma delimited file to a database using ASP.
Has anyone tried doing this before? I'd love to know how you did it. At the moment, I'm thinking of uploading a file, opening it with FSO then creating an array (or something similar) from the content of the file. If there's an easier way of doing this (with components etc) please let me know.
I need to Ban IP's on my IIS server. I know the IP's I need to ban, but how to I write the global.asa file correctly.
View Replies View RelatedWe have aan asp content management system running on IIS6 that produces hundreds of pages from one page template so each page is called mainpage.asp?id=22 and the number at the end changes.
Is there any way of attaching a virtual address to the pages so they could have for example news_story or about-us and control this using a database?
i have a little problem , if i want to get as a result of this code:
<a href="<%= rs.fields("fxurl") %>" target="obsah" style="text-decoration: none" ><%= rs.fields("fx") %></a>
a link named "something" and when you click this link youŽll get to "somewhere" , so when "somewhere" = "page.asp" it works fine but ....
I have the following code which imports a csv file into the database. but when i run the code i get this error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
BUT it's imported all the data Code:
I've seen lots of posts on this and other boards, but nothing seems to work for me. I need to import data from an Excel spreadsheet using ASP. None of the ranges in the spreadsheet are named. I'm using this code:Code:
<%
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
ExcelConn.Provider = "Microsoft.Jet.OLEDB.4.0"
ExcelConn.Properties("Extended Properties").Value = "Excel 8.0"
ExcelConn.Open "c:inetpubwwwrootaspcalendar est.xls"
set ExcelRS = ExcelConn.Execute ("SELECT * FROM [Sheet1$]")
Response.Write(ExcelRS($A$1))
%>
I've tried every variation on "ExcelRS($A$1)" that I can think of - I've seen "ExcelRS(1,1)" used, but that doesn't work... What is the syntax for accessing Excel data by cell coordinates?
I have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .
View Replies View RelatedI am trying to get the all data from my excel document. I almost can.
But there are some colums that I can't get!P1aP2b
because there is no column at the start of them!
the all I can get with asp is just data not data name (field name) Code:
I have intermediate experience with asp, and sql. I am stumped on how to properly do a project, and hoping that one of you can point me in the right direction instead of playing the trial/error game for 2 weeks!!
Basically, I have a program that exports information into a html file for viewing of results. The file contains event information, user information, and results of each individual user along with statistics of the event. I want to take this generated file, and import it directly into a sql database (point and click upload of sorts to be user friendly) for further data mining. Code:
I was having a go at importing a page written using HTML embedded with some ASP and SQL commands into an Excel sheet.
Now I have tried using the command below and no luck. After doing some Google searching I found some people suggesting removing HTML and BODY tags which I did but no luck. Tried using HTML and BODY tags and still no luck and all of a sudden I hit a brick wall. Code:
ive got a piece of software (perl) that i use to track visitors on my site.
this software displays both ip addresses and domains of visitors
e.g.
A visitor from 81-178-202-110.dsl.pipex.com (81.178.202.110)
arrived without a referring URL,
and visited www.newmediadesigns.co.uk/index.shtml
at 03:01:28 PM on Friday, March 26, 2004.
This visitor used Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1).
what code do i need to display this domain information in asp?
I want to block certain email addresses like,(See the MailTo Section, I don't want the Sandra email address), through my online forms. I've been receiving spam from people using the forms. My code below is ASP. The code basically sends the form data to 3 email addresses and send the visitor who filled out the form an HTML style email message as confirmation. I added an IF THEN statement (Look at the MAIL TO) for the unwanted email address thinking it would do the trick but it doesn't block or send the email to the unwanted email address. Here's the beginning of my code. Any help would be greatly appreciated. NOTE: I replaced the wanted email addresses with phony names because they are private.
<%
If request.form("Email")="" then
response.write "<p><br><center><font face='arial' size=3>"
response.write "<b>Please don't forget to enter your"
response.write " Email address!</b></font>"
response.write "<form>"
response.write "<input type=""button"" value=""Return to Form"""
response.write " onclick=history.go(-1)></form>"
Else ........
I want to search email addresses through phrase, for example there are 4 emails in the database like
abc@yahoo.com
abc1@yahoo.com
abc2@yahoo.com
abc4@yahoo.com
and i want to search thest all 4 email addresses through a phrase like 'abc'
Simple question no doubt -
I am trying to send an email to a form variable as well as a list of addresses, but I can't seem to get it to work. Please help.
I want to combine these two lines - what is the syntax?
Code:
MyCDONTSMail.To= "xxxxxxx@nzl.xerox.com"
Code:
MyCDONTSMail.To= creat_email
They work individually (I have declared creat_email).
I'm looking at including the functionality of allowing the user to enter their ostcode / number and for the rest of their address details to be retrieved and populated.I have seen one or two solutions via google but these require you to pay, and I was wondering if this is something that can be achieved for free?
View Replies View RelatedIm currently working on a simple form which only contains one text box, I would like it so that the content within the box is e-mailed to a specific address but for the senders e-mail address in the From line remains anonamously masked in some way. Is this at all possible/ any tutorials on this?
View Replies View RelatedI am working on a project that involves importing IIS Log files into a SQL
Server database (and these logfiles are big --> Some up to 2GB in size).
Up until now I thought that DTS or the BULK INSERT command was the fastest
method out there, but still proves to be long (taking an average of 45mns to
an hour to process each log file).
Because I have to import the log files from three web heads in my cluster
(therefore 2GB log files per server times three servers), this really throws
off the concept of "real time" or near "real time" reporting.
So that begs the question. WHAT IS THE MOST EFFICIENT, AND QUICKEST
TEXT-FILE TO SQL SERVER IMPORTING TOOL, METHODOLOGY, SAMPLE CODE, WHATEVER,
OUT THERE??? Code:
Am tying to build a system where you can browse and upload files into a MS Access database.
View Replies View RelatedI've been asked to develop a semi-automated type situation where we have a
database table (sql server) and periodically, there will be a comma
delimited file from which we need to import the data, replacing the old.
I naurally know that we can use [truncate tablename] to kill the other data,
but does anyone have any examples of importing a comma delimited file into
SQL Server with ASP?
I want to store multiple mailaddress like home address and shipping address. Sometimes addresses will be more than two. I am thinking about storing the details as a dictionary object....
View Replies View RelatedI am wanting to validate the domain name of email addresses submitted through a form. Has anyone written a script for using nslookup to do this? My searches are finding components for sale.
View Replies View RelatedI want to search email addresses through phrase, for example there are 4 emails in the database like:
abc@yahoo.com
abc1@yahoo.com
abc2@yahoo.com
abc4@yahoo.com
and i want to search thest all 4 email addresses through a phrase like 'abc'
I have an ASP page that emails the user who entered their email in the form, which could be an external or internal address. Internal addys come in the form of: symthe, poncenby
when this is type manually in an outlook message it gets resolved as being on the global addres list.
Testing at the moment consists of me emailing myself using the TO field being an external address and the FROM field being internal. The email get to me but the sender's address is just the first part of form value before the comma. e.g. smythe .
Importing EXCEL worksheet into existing ACCESS tables is possible.
Is there any way i could import EXCEL worksheet into an existing ACCESS table using ASP code.Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table And if possible also check for duplicate keys and update those records. If no records exist then insert them.
I want to send an emailshot from my ASP/VBScript page without disclosing the email addresses of its recipients in the To: field. I've only considered CDONTS. Can it do this? Or is there another way?
View Replies View Related