Ms -access help

[NYCpal]

Excel sheet lo data undhi ...already access lo unna data ni replace cheyali with the variables as per in excel ,Koncham guide me .

ex:excel lo name age dob address ela data Unty ; access lo age name address Ee sequence lo data kavali 

[150bryant]

first import file into Access.

if successful then post here.. we can do next step

[NYCpal]

15 minutes ago, 150bryant said:

first import file into Access.

if successful then post here.. we can do next step

Adhy Mari ...excel lo diff names for variables kinda mapping cheyali ...telisthy cheppu 

[150bryant]

6 minutes ago, NYCpal said:

Adhy Mari ...excel lo diff names for variables kinda mapping cheyali ...telisthy cheppu 

bro.. once u get the data in to ms-access.. it becomes a table

u can write sql query to get data in watever type u want.

lets assume u the excel sheet in to the ms-access. now ur sheet name is table1

u can create a new table from table1 as u like...

select   age name address

from table1 

ani kotha table create cheskovachu

[NYCpal]

2 minutes ago, 150bryant said:

bro.. once u get the data in to ms-access.. it becomes a table

u can write sql query to get data in watever type u want.

lets assume u the excel sheet in to the ms-access. now ur sheet name is table1

u can create a new table from table1 as u like...

select   age name address

from table1 

ani kotha table create cheskovachu

Bro ...Neeku access , vba vacha...nannu tiskoni poyi Ee new project lo tosaru..I don't kno where to start ..Koncham guideness kavali ?

[150bryant]

1 minute ago, NYCpal said:

Bro ...Neeku access , vba vacha...nannu tiskoni poyi Ee new project lo tosaru..I don't kno where to start ..Koncham guideness kavali ?

access varaku ok. i hate tht vba.

data entha undhi?  how many records?

[NYCpal]

1 minute ago, 150bryant said:

access varaku ok. i hate tht vba.

data entha undhi?  how many records?

At this moment data ekkuva ledhu ...it's an inventory database ...Neny build cheyali ...thy r expecting me to create tables (info email chestaru diff internal teams) ; from then a teams future lo how much inventory a particular team in particular , particular product has been ordered by diff team , cost entha dani Kosam Ee database use chestaru ...

[NYCpal]

Ltt

[Maryadaramanna]