ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

4 Q & A posts tagged with Database

Sun
Nov 13
2011

How many tables needed? urgent plz?

A Manager of CNG station is interested to design a database to accommodate all CNG relevant information. He wants to keep the record of all vehicles, regular customers and all transaction relevant to customer and suppliers. Moreover manager is interested to generate different report relevant to see information about daily weekly or monthly sale and profit record. On some occasion manager of CNG station offer different sale discounts, so he is also interested to keep the record of all discounts. Similarly, manager also using monthly billing system for some type of regular customers.
Q1. How many tables needed.
Q2. design tables.(optional for you viewer :P )


Answer

I would say at least 5 tables
Customers
Vehicles (one customer can have more than one vehicle)
Supplies
Services (To have actual service provided with Customer id, supply id, vehicle id, billing id, etc)
Discounts

And you can add
Billings (to have bills, with Costumer Id, amount, service id, discount id, etc)
Employees



let me know

Sunday 11/13/2011 7:12:14 AM
Fri
Apr 2
2010

Database records exported to Excel CSV encode language characters?

I have database records that use different language characters (European languages mostly). When exported to Excel file, CSV to be exact, these characters are come through as encoded. I have an example here, characters "zlw" output as "zlw". I tried "charset=UTF-8", "charset=ISO-8859-1" and nothing. Any ideas?


Answer

You might need several attempts
- Copy the CSV file, in case you messed it up
- Open the CSV file in NotePad (Open NotePad, drag the file to it.)
- Do "Save As", now what is the suggested format of the file?
- I recommend importing the file in Excel instead of open it
- In both cases, use the same format used in Notepad

I faced issues like that when I work with Arabic/Hebrew chars, and these steps usually work it out

If not, then pay attention to the format when you export the data from the database, most database applications give you the ability to choose the format when export

Good luck and don't forget, VBAXLMan is here

Friday 4/2/2010 3:25:51 PM
Sat
Apr 25
2009

MS Office 07 Excel/Access question 10 pts best (right!~)answer?

how do you LINK (not import) an excel worksheet to an Access Database that is already in existence (this database was created by importing data from a separate excel worksheet). I'm stumped! Will award 10 pts best answer! :-)


Answer

When you open Access, and create your database
Go to External Data > Excel
And in the wizard, select the third option (Link to the data ...)

This will create a table that is linked to the Excel spreadsheet.


VBAXLMan

Saturday 4/25/2009 9:00:15 PM
Sun
Apr 23
2006

Where can I find the file WD H-4.mdb?


Answer

It is Microsoft Access database file, did you try to google it?

Just search for that full file name in Google or yahoo


Good luck

Sunday 4/23/2006 4:42:31 PM

Tags

History