Originally posted by: vineet
How can I convert the Excel spreadsheet into Ms-Access database,Please any one know about it than suggest me method.
Thank's
Originally posted by: Murali
Hello,
I am working on a project in VB 6.0, Access 2000 in Germany. As this is my first project in Visual Basic and i dont have much knowledge about Access i am facing many problems. I hope you will reduce my strain to some extent.
The company where i am working manufactures water meters and test them for water flow, heat etc etc...so all these data was stored in different formats because of different development periods. The data in Access 97, dBase 3, and Ascii(text) formats. Now all these should be converted to Access 2000.
They need a software to be developed in Visual basic 6.0 to convert these format into one single Access 2000 format. So how can I convert them into one. PLease guide me. If you have any sample programs with code please send me.
Hope you will do it for me.
Thanks in advance.
Murali
You can write the code to open database in VB using connection object i.e. Dim cn as new ADODB.Connection...write the code to open access 97 database...write the logic using OpenRecordset method to insert in the new database table. similarly open for DBASE
ReplyOriginally posted by: Nadeem
I need to develop a datareport in VB which diplays data from more than 100 fields of 6 tables from Oracle server.
Using a dataenvironments command recordset set to a select query with many relations to connect the table (it is time comsuming ), Please do suggest the procedure to write a stored procudere to access the same 100 fields using more than 1 select query.
Originally posted by: gagan kalia
i wannt to know is there any way to stop copying the file in any operating system for a particular file through visual basic or any thing.
Originally posted by: gagan kalia
i wannt to know is there any way to stop copying the file in any operating system for a particular file through visual basic or any thing.
ReplyOriginally posted by: Girish Chaudhari
Hi !
I am developing one small project in vb with Access as backend. I have on problem while creating a table with the help of query..
eg.
Select * into table XYZ from database
The Table XYZ should be created on my temperory directory on my local machine harddisk . so what should i do.
Please help me..
Regd
Girish
Originally posted by: Guruprasad T.N.
As i need to achieve Master/Detail relation form, i'm using header and detail section for the header i'm using dbcombo list box which will contain the data from one of the master table and acts as a primary key and for the detail i'm using True dB grid7 and placed one drop down combo box as of the field which will populate records from one of the master file and the placed the foreign key also but made visible property false.
If some one having the same type of problem please try to send me a source code with screens or guide me in completing this program properly
Thanks in advance
Guru
Originally posted by: Rithi Patel
Give any solutions for this.
I am developing a software using VB as frontend and Access as backend.
I have problem of join query for more than one tables. If I'm using Access-97 the query doesnot work, but if I'm using Access-2000 the query works. That is, I am not able to insert records in 97 version, but I am able to view the records and navigate the record set.
Originally posted by: Purushottam Singh
Now that I have include this file in reference and I could directly use the function.
eg.
dim a,b as variant
MsgBox NZ(a,b)
it will give the value 4;
I could do it only when I declare the object
dim o as object
Is There any other way to do the same thing just like above one.
There are many functions in Access Liberary(.dll file)
among them <<<<nz(,)>>>> function
a=null
b=4
Now this is my problem.How could we do the same thing in activex dll.
set o =new recObject
.................
Originally posted by: M.ADNAN RASHEED
i am creating vb database software with access as data base but problem is that it donot launch the database
so what should i do.
Reply