prasad joshi
Last Activity: Dec 22 '12, 06:26 AM
Joined: Aug 6 '12
Location:
-
how to export excel data to access table
I am trying to figure out a way to export any new data entered into an Excel 2003 spreadsheet into an Access 2003 database from the Excel application. I've seen lots of code originating in the Access application, but I want to avoid having to go into Access to do it. The users will be entering data into Excel daily, but no one will be in Access daily- and the info needs to be up to date because it is a source for another application(an Infopath 2003... -
I am writting in oracle sql editor -
Access database online like Oracle
hello
can we do online operation using access database[application] like we do in oracle???
please help -
How to make indexed or linked table
Hello
I am developing a access application.
The problem is in every month I get 8 gb of data .
I want to make a access application such that it should store 8 gb of data in every month.
Please help me
How to design such application???
can access 2007 will hold 8gb of data in every month?
how to resolve this problem
I am new to... -
error in code UTL_FILE
hello
I have got this error.
ORA-06550: line 2, column 5:
PLS-00201: identifier 'UTL_FILE' must be declared
ORA-06550: line 2, column 5:
PL/SQL: Item ignored
ORA-06550: line 5, column 4:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 4:
PL/SQL: Statement ignored
ORA-06550: line 6, column 22:
PLS-00320:... -
SQL PLUS means????
I will have to use sql server2005 for executing spool command???
I am not getting.
Please Help.Leave a comment:
-
I have installed toad only
and not oracle.
Is it necessary that we should install oracle before installing toad????
I hadn't known.....
plz replyLeave a comment:
-
problem in spool command
hello
I am writing code to store output of sql in txt or excel
I have tried following code
but it gives me error that
ORA-00900: invalid SQL statement
is script runner required for executing this code???Code:spool output.txt select * from emp; spool off;
am I using spool command correctly???
Please help... -
toad login
hello
i have installed toad for oracle 32 bit version on my pc
.
i have single home pc. it is not connected to any network
i am using toad for oracle study
but when i start toad
it asks me this
username
password
databse name
connect using
direct
ldap...paramete rs
just now i have installed toad on my standalone... -
Calculations are usually handled in the query or the report at runtime.
means what
can we do complex operations on report at run time?????Leave a comment:
-
how to insert data in access table
i am making a program
in that i am doing calculations
after doing calculation i want to store calculated value in another table
but i dont know how to insert calculated data in table
program gives error in this part of code
...Code:...................................... rs.Edit rs.Fields("vol") = ("strComp") rs.Update ...........Last edited by zmbd; Sep 4 '12, 05:22 AM. Reason: (z) Added code tag to first section. Removed extra returns and stepped code in second section of code. -
i want complex functions.....
i know this one .......Leave a comment:
-
query calling function
hello....
i have heared that we can call a function by using access query
i dont know how to do this
can anybody give me example........ .. -
how to search word in text file using access vba
guys
i have text file and i have to serch word in that file using access vba code
i am not understanding how to write code for searching particular word.....
i have tried following code BUT THERE IS PROBLEM
...Code:Dim objStreamReader As StreamReader Dim strLine As String 'Pass the file path and the file name to the StreamReader constructor. objStreamReader -
yes user know location and name...
please tell meLeave a comment:
-
third case that is c)
plese help me urgentlyLeave a comment:
-
how to take input to our application
hello.......... ..
i am developing access application
in that my application should take input database for every operation..
how to implement this
the method should be user friendly.....
i dont want to use inbuilt import database method of access
for ex:
i have access application . in that i have written queries and vba which extracts... -
can you tell me how to create temporary table to hold imported data
this table should be dump after entire operationLeave a comment:
-
what to use for holding imported data
hello...
I want to import table in my application and i want to store it temporary so that i can make calulation
after making calculation that temporary data should be dump
how to implement this program
how to store i/p table temporary in my access vba application
I am new to this.... -
How to access another database in my application
i want to access values of another database in my vba application
how to use it
can anybody give me sample code....
No activity results to display
Leave a comment: