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.
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.
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.
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 .
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 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:
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?
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'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.
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be. Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /admin/update.asp, line 111 line 11 is strName.execute I read it might be forbiden characters in the data base field names or spaces... but i don't have that. the names are userName, userLevel, ID, Password.
This seems a very complicated task, so I welcome any input. My boss wants a data grid or matrix of the top 6 orders with ordered items, and products, for a particular customer and he wants to see it like this:
products down the left side orders across the top number of items under the respective order number column across from the corresponding product.
I hope that makes sense. I have three tables. Products, Orders, Orderitems. I don't even know where to start. Many thanks in advance for any input offered.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
How can I display data from an XML file in ASP?I want to use an XML file instead of an Access or SQL database and would like to display this information the same as I would if I were using Access or SQL as the datasource.
how to add new data. i need to add new data after display the record from database. i click new button and the textbox will be empty. Wat is the code for add new data?
I had write an asp file to get data from an xml named "data.xml" and below is the coding:
Dim xml Set xml = Server.CreateObject("Microsoft.XMLDOM") xml.async = False xml.load (Server.MapPath("data.xml")) Dim fText1, fText2 fText1 = xml.documentElement.childNodes(0).text fText2 = xml.documentElement.childNodes(1).text Set xml = Nothing
It's all Ok and can run. But my problem here is I want to call an xml file that I don't know its name (not "data.xml"). The xml file pass by the user who call my asp file. The user can pass the xml via anything for example asp or VB component. So I will not know exactly what the name of the xml file.
i have setup a DSN called "pro" now i have tables in this database i m running oracle if i were using MS Access i know how to insert new fields by using the
RS.Mode = adModeReadWrite
how do i do it for oracle? not just inserting data into tables but also what r the commands that i have to give in the asp code page so that i can even update( edit ) and delete records.