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?

View Replies


ADVERTISEMENT

Importing From Csv

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.

View Replies View Related

Importing From SQL To ASP

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

View Replies View Related

ASP And IP Addresses

I can't find the code to display the client IP address on
the client browser. Shouldn't it be 'session. '?

View Replies View Related

What Are The IP Addresses

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 ?

View Replies View Related

Importing Csv Into Access Db Via Asp

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.

View Replies View Related

Importing .xls To MSSqlserver

Can anyone tell me how to exactly import excel sheets into sqlserver from the dts?

View Replies View Related

Importing .CSV File

I'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 Related

Importing Data

Is 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.

View Replies View Related

Global.asa To Ban IP Addresses

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 Related

Virtual Addresses

We 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?

View Replies View Related

Web Addresses From 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 ....

View Replies View Related

Error When Importing Csv File

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:

View Replies View Related

Importing Excel Cells In ASP

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?

View Replies View Related

Importing XML Into Access 2000

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 Related

Problem With Excel Importing

I 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:

View Replies View Related

Importing Files To Database

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:

View Replies View Related

Importing ASP Page Into Excel

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:

View Replies View Related

Converting IP Addresses To Domains

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?

View Replies View Related

How To Block Email Addresses

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 ........

View Replies View Related

Search Email Addresses

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'

View Replies View Related

Multi Email Addresses

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).

View Replies View Related

Finding Addresses From Postcode

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 Related

Masking Email Addresses

Im 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 Related

Hyper-efficient Text Importing

I 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:

View Replies View Related

Importing Data From Excel Into Access Using ASP

Am tying to build a system where you can browse and upload files into a MS Access database.

View Replies View Related

Importing Comma Delimited File

I'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?

View Replies View Related

How To Store Multiple Mailing Addresses

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 Related

Using Nslookup To Validate Email Addresses

I 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 Related

How Can I Search Email Addresses Through Phrase?

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'

View Replies View Related

CDONTS, ASP And Internal Email Addresses

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 .

View Replies View Related

Importing EXCEL Worksheet Into Existing ACCESS

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.

View Replies View Related

Mailshot Without Disclosing The Email Addresses In The To: Field

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







Copyrights 2005-15 www.BigResource.com, All rights reserved