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'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 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?
How would I import a file thru an asp page and then validate the fields in
that file - the file would be comma separated file (CSV or Txt extension).
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'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 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'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 RelatedWe 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 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:
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:
Am tying to build a system where you can browse and upload files into a MS Access database.
View Replies View RelatedImporting 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'm using asp to retrieve data from a server and import that data in a client that uses MSAccess, into a memo field. The text hes line breaks 0D 0A (the usual DOS line breaks). However the client sees these line breaks as two squares!
The strange thing is that when I look at the exported text (yes, I also export text from the client to the server), it also contains the same line breaks. So the exported text from the memo field can look exactly the same as the imported text, and before the export the line breaks are correctly shown als line breaks, but after the import that same line breaks are shown as squares! I would like to see line breaks after the import and NO squares.
Past few days I see following errors in Event Log after which few ASP scripts stopped working (or part of it's functionality - not very sure which one).
"Error: File /trxweb/trxweb.asp Unexpected error. A trappable error
(E06D7363) occurred in an external object. The script cannot continue
running.."
Source : Active Server Pages
Event ID : 5
Category:None
What could have caused this error ? We are using IIS 6.0. This happens between 3:00 pm and 6:00 pm. User not is on an avg < 40.
Here is the code in ftpRun.asp:
<%
set wshell = server.createobject("wscript.shell")
wshell.run "D:Inetpubwwwroot
ewjoshOFP
5995AconsistencyftpRun.bat"
set wshell = nothing
Response.Write "Files Updated Successfully!"
%>
Here is the error I get when I run ftpRun.asp:
error '80070483'
No application is associated with the specified file for this
operation.
/new/josh/ofp 5995a/consistency/ftpRun.asp, line 4
Any ideas how to fix it? Any other ways to accomplish the same goal
on a NT4.0 machine without adding components?
I am getting an error:-
File 'C:Pathfile1.txt' does not exist
I am selecting a text file from the previous page to put into the database. When I hard code the file path it works fine. Any ideas?
When I type out my new stuff in the edit field I click submit and get this error. The next post is my code for the entire page.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/hwnetwork/edit1.asp, line 110
I am trying to delete a file off a server (same server asp app is running on). I have done this before and not encountered any problems.
The code I am using is:
Set File = CreateObject("Scripting.FileSystemObject")
ImagePath =
Server.MapPath("......sectionsezineeditionsimagesarticlethu mbs")
ImagePath = ImagePath & "" &
(RS_Content.Fields.Item("CON_Issue_Number").Value) & "" &
(RS_Content.Fields.Item("CON_Image").Value)
However, I am getting an error pointing to the last line of code above:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
I'm sure I am missing something simple from staring at this so long.
I have perhaps not explained myself clearly, so I'll try it this way.
In the code below, where it says "I'd like to include my navigation
bar here" is the place I'd like to insert a navigation bar from a page
I have called navbar.asp
For some reason, when I insert the <! #include file="navbar.asp" -->
in that place, I get an error, a long, hairy error. Can you please
look at the code below, and tell me how I should write the code so
that the include statement will work? Code:
We recently moved our webserver from Win2K to Win2003. The application works fine. Only problem is that when user views a report as a PDF, IE does not show it. The following code is used to redirect:
Response.Redirect("/website/pdffiles/myreport.pdf");
Response.End;
IE opens a "File Download" box and if you click the "open" button then nothing happens. If you click the "Save" button the following error comes up:
"Internet Explorer cannot download "myreport.pdf" from "website". Internet Explorer was not able to open this Internet site. The requested site is either unavialable or cannot be found. Please try again later."
if I use the following code: ....
I have a form that has many fields on it (selection list, text areas, etc) as well as the ability to upload some files. I'm using Lewis Moten's upload code (works great). No problem so far. However, if the user has a typo or the file does not exist then I want to return the user to the original form with an error (invalid file) and all of their work the way it was before the submission (i.e. if they had selected something from a list - when returned to the form the selection is kept).
Because I'm uploading files I have the form set as this:
<form method="post" encType="multipart/form-data" action="addform.asp">
In my addform.asp, I have a check for a valid file:
set objUpload = new clsUpload
if objUpload.Fields("document").Length = 0 then
' redirect user back to original page with an error
Response.Redirect addform.asp?error="invalid file"
end if
On the original form, I have quite a bit of data - may exceed the querystring maximum.
error in file upload
Error Microsoft VBScript (0x800A0007)
Insufficient memory: RequestBin
happened uploading a file of 3.5MB, but before it did not give error me. that it can be?
There is an ASP page in my site which sometimes gives file not found error. This page which is suppossedly missing exists on the server and available most of the time. But
sometimes out of the blue, we get this message. When we restart IIS, the page works fine.
The rest of the site is usually fine. This one page gives the 404 error consistently. Obviously anything after this page could not be accessed. There are some other ASP pages as well which become unavailable (giving file not found errors) from time to time.
just wondering if anybody has encountered this problem before ? I'm trying to upload a file using an ASP component that came with a web app Code:
View Replies View RelatedI am getting one error while downloading a file (DBF file) through aps page. the error is: "Can not access file because the file is being used by another process". First My asp page creates a DBF file programmatically using OLEDB provider and saves that file at a particular location. In the same asp page I have given link to download the file on client machine.
above operation will be performed based on the flag set in my code. if flag is 'Save' it will create the DBF if flag is 'Download' it will download the DBF. I am using ASPSmartUpload component to download the file. and i am calling DownloadFile method of this component. But it is giving me error as mentioned above. I have closed the recordset and connection object and set it to Nothing. but still it is giving this error. This works fine for the first time and after that it gives this error.
please tell me what could be the reason for this and how i can handle this programmatically. is there a way to find out whether the file is in use or not and if yes then how to stop that process?
I'm using a free component to upload image files to the web server. I'm getting this error when I try to upload
SaveBinaryData error '800a0bbc'
http://m.rbgdesign.com/southernlumber/flowers 003.jpg:Write to file failed.
/southernlumber/_Upload.asp, line 903
I know that I have write permissions for this server. Maybe my path is incorrect. How can I solve this?
I have created one dynamic chart creation application using vb dll. If I call this function from vb it is working fine. But If i call this function from ASP i got error while opening the excel file line. I have windows 2000 server. Do i need to give any permission for this? The same coding is working fine in NT server.
View Replies View Related