question

[Guest]

i wanna create a software using access. my backend will be visual basic and
front end will be ms access. i wanna feed entire datas from excel to access.
so guide me

 

[Guest]

Ravi,
Tell me a little more about what you want to do with excel and such. What do
you have thus far and so on.

-Brandon

 

[Guest]

Hi,

i wanna create a software using access. my backend will be visual basic and
front end will be ms access. i wanna feed entire datas from excel to access.
so guide me

I think you need to brush up your basics about VB and Access. Access is a
database product that acts as a container for Tables (data), Forms (user
interface), Reports (output) among other things. It uses Joint Engine
Technolgy(Jet) as the database engine and Visual Basic for Applications (VBA)
as the programming language.

VB is a pure programming language which is slightly different from VBA, and
definitely not a database (though VB can connect to Databases such as Jet,
Oracle, SQL Server etc).

If you want to build a database, and in Access, you won't feel the necessity
for VB. Every Access db comes with a VBA project. Access and VBA go together
nice and smooth.