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
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
i often to make a user interface in access for data entry using Grid view. is there a possibility to make Data Entry user interface using Grid in ASP?
View Replies View Relatednowdays 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
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 View RelatedI 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:
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
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>.
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:
I have excel file,from which the all data to store the .mdb database. Any one give an idea.
View Replies View Relatedi would like some assistance in creating a user interface that reads from a database.
View Replies View RelatedIs asp/asp.net able to interface with the PC's I/O ports? I'm currently doing a program on VB using the SDK from the vendor to interface my biometric scanner to my PC using usb port. Can this same thing be done using asp?
View Replies View RelatedI made this little application-variable interface to help me see what application variables/values I currently have on the server and it lets me easily add or remove single variables, remove all the variables, or re-create the variables I declare in an ASP file called "CreateVariables.asp". Code:
View Replies View Relatedi'm getting a bit cought up with the ASP for a poll creation page i am trying to do.
i am trying to get it so that it will display a varying number of boxes depending on how many options there will be - have it so that it displays the first 2 (the minimum options) and then the other input form elements will be added as needed i'm also having a bit of trouble trying to get the numbers to update with the onchange but that part doesnt feel like its the most challenging - heres what i have so far: Code:
how to access Outlook methods to generate an "add contact" event on the local user's machine. Most of the info I'm finding relates to Exchange server, not the local instance of OUtlook.
This event will be spawned from an intranet-based ASP page. The online contacts list will have a button to add the contact. On click, the default contact form will be displayed, with the primary fields pre-populated from the recordset selected. I'm sure this is a no-brainer, but haven't done this before.
Is it possible that my asp web application can interface with the hardware? like the PIC or the microcontroller? and if it is possible, what im gonna do?
View Replies View RelatedI'm moving away from Access db's to MS SQL Server databases for storing form records.
While the MS SQL Server provides all the tools I need to edit/delete/add records, I need to provide an interface for non-technical people for obvious reasons.
I have a halfway decent one for manipulating Access databases but it doesn't seem to translate over to SQL Server too well. Obviously I'm fairly new to ASP and SQL but I've tried everything to make this editor work for SQL server.
So, I would like to just start from scratch and ask if anyone has an asp script that acts as a front-end to edit/delete/add records - nothing too fancy.
We got two interface. Staff and member. When member login, they are brought to member's page. However, when staff login, they are also brought to member's page. This is because at Dreamweaver 8, we have specified that if login succeeds, go to member.asp.
So how do I make sure that when staff login, they go to their staff.asp.? Is it by command procedures or SQL or some kind of other function? Much help needed! Project deadline is just around the corner!!!
I'm having a problems when trying to make a DLL in VB6. The code is using ScriptingContext to access the Cookies-collection from the asp-pages, but when I try making the DLL I get the following error-message:
**************
Compile error:
Function of interface marked as restricted, or the function uses an
Automation type not supported in Visual Basic.
**************
When I click OK, ScriptingContext.Request.Cookies is marked. Could anyone please help me with this problem? I'm more of a .NET guy but some of the applications that I'm in charge of are still using ASP and COM+ so unfortunately I'm not too familiar with these techniques.
I am wondering if it's possible to simulate the Multiple Document Interface
in ASP/ASP.NET webpages? Maybe using DIV layers? I am trying to create the
little document windows in an application, but in a webpage. I need
dragging, overlap, focusing, resizing capabilites. Also must be able to
encapsulate another DIV layer within this DIV layer. Is this possible?
Does anyone know a library (already-made) div/layer MDI windows for
webpages?
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.
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"""
how to import the rtf format content to word file.
View Replies View RelatedI 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.
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 RelatedI have created a user lists from a database (UserProfiles.mdb) using asp. There is the possibility to click on the different usernames in the list to go to a page with more information about the user:
the link to this page is: <a href="test_bis.asp?userid=<%=userid(j)%>"><%=un(j)%>">
when you click, it works, e.g. http://localhost/Test/DataQuality/U...s.asp?userid=15
My problem is that I need the variable userid to create the new page. I made a test to see if this variable was "imported" in the new page and thus with: Response.Write userid, but I do obtain a blank!! Code:
I'm importing data from a csv file but have the following problem.
It see any comma in a specific column as the end of the current column and move the rest of the values into the next column I.E Data from column 4 display as data from column 5.
I do know that it's comma delimited but would like to know if there's no way that I can distinguish between the commas in a column and the commas that indicate a new column.
Col1 Col2 Col3 Col4 Col5
Value Value Value Val,ue Value
How do they do it in excel?
i have used this code for importing Excel files to the database but always get this error: >> Syntax error in FROM Clause: Code:
View Replies View RelatedI planning to create a calendar function which bind to the Microsoft Exchange Server. I need to know how can I retrieve the Calendar information like appointment, meeting and etc from the exchange server by using the ASP
View Replies View RelatedMy Goal I want to load from a CSV File into variables so I can use the values in a procedure I've developed. But I'm stuck on how to access values from a csv file. If everything were to be in a Database everything would be just easier but sometimes you don't have the options of having a database.
Now what I'm wanting to do is load the output into asp variables so i can use them in a procedure I've created. Code:
How can I import a generic unit (such as system, system.data, system.data.oledb) in an asp page ? Where should I put the above code ?
Need sample code, please for ASP pages, and for ASP .net pages (aspx).
I' m trying to import an Excel file in a SQLServer db. If I specify the spreadsheet name it works correctly. Now I'd like to import the spreadsheet without specify its name. Is there a way to retrieve the spreadsheet names of my Excel file in ASP?
View Replies View RelatedMy company recently hired a third party to handle phone orders during off hours. The third party wants to be able to update our database through their own interface. We are running SQL Server 2000 on Windows 2000 Server with ASP.NET 1.1. The number one thing that come to mind is security for credit cards. Perhaps some kind of web service, xml, etc.? Does anyone have any suggestions on the best way to handle this?
View Replies View RelatedI am trying to import an excel spread sheet, my first step is to be able to see the spreadsheet on the webpage, Code:
View Replies View Related