How I can Make access database using Excel files?

[tegoxx]

Emm,,,, first sorry for my english
I want to ask ,, how to make access query connected to MS Excel,,,
example : if I want to find name of someone,, I just write name and address , and then the Access can take the data from Excel,,, so I can know all about that without open many Excel data ......Thankz please help me,,, please...

 

[tegoxx]

Help I can't thinking about that anymore,,,, my head very sick,,,,

 

[JHB]

Emm,,,, first sorry for my english
I want to ask ,, how to make access query connected to MS Excel,,,
example : if I want to find name of someone,, I just write name and address , and then the Access can take the data from Excel,,, so I can know all about that without open many Excel data ......Thankz please help me,,, please...

Import the Excel sheet into a table in MS-Access and then run a query.

 

[tegoxx]

how to do that ??? please help me

 

[JHB]

how to do that ??? please help me

Open MS-Access and create an new database, then from the menu line choose "External Data", then from the Ribbon, "Excel".
Below is a link which describe it step by step.
http://office.microsoft.com/en-us/a...ata-between-access-and-excel-HP001095095.aspx

 

[tegoxx]

I mean,, emm I'm not Import,,, I mean the access can using data from excel but not Import that,,, just linked and,, if excel data edited,,, in access edited to... help thankzzz

 

[JHB]

If you think you have the solution, then use it, good luck.

 

[tegoxx]

No ,,, I don't have solution,,, I still searching,, but is very difficult ,,, any one ,,, ?? have solution?

 

[JohnLee]

Hi,

From your posts it looks like you want to use access to search Excel Spreadsheets and that's it.

Whilst you can link to a spreadsheet from Access, it's not just a matter of doing that and away you go.

You can import you spreadsheets into access and you can update data in your database from your spreadsheets as and when they take place, but you will have to build those actions into your database in order to do that.

You need to take some time to fully understand how access works and identify clearly what it is you want to do with regards to managing your data in the spreadsheets.

Personnally I think you need to make a decision as to whether or not you want to continue to use spreadsheets or make the jump to Access to manage your data.

Access is extremely powerful and offers you plenty of scope to acheive your requirements, you just need to be prepared to make the jump or not, also just asking for help without providing a good level of information about what it is you want to acheive will not get you the kind of help your looking for.

Be clear and concise about what it is that your spreadsheets are currently being used for and what it is that you can't do in a spreadsheet that has prompted you to look into using Access to achieve those requirements.

Provide some sample spreadsheets to enable any person that might be willing to assist you with your project to see what it is you are working with, which may give that person the ability to provide you with the kind of help you are looking for.

Regards

John