Microsoft Access - How to import .xsd files in access

Asked By s p on 21-Apr-11 01:27 AM
How to import .xsd files in access
I want to view the schema in access database..
TSN ... replied to s p on 21-Apr-11 01:36 AM
HI..

GO througth the Following Steps...

In Access, you can import data from an XML document or an XSD schema. The following steps describe how to do this:

  1. Open a database, or switch to the Database window for the open database.
  2. On the File menu, point to Get External Data, and then click Import.
  3. In the Import dialog box, in the Files Of Type box, select XML Documents (*.xml;*.xsd).
    Note   importing XML into an Access project (ADP) requires that the MSDE or Microsoft SQL Server™ installed locally.
  4. Click the arrow to the right of the Look In box, select the drive and folder where the file is located, and then double-click its icon.

    The Import XML dialog box displays a list of tables contained within the XML document or defined in the XSD schema.

    Note   All of the tables shown in the list are imported. You cannot select a subset of tables to import.
  5. To start importing the file, click OK. This completes the import procedure.
    Note   For most records that cause an error, Access creates and adds a row to a table called Import Errors. To view the list of errors that were encountered, open the Import Errors table from the Database window.
  6. To set options for importing XML Documents, select one of the following under Import Options:
    • To import just the structure of the table, click Structure Only.
      Note   If you are importing an XSD file (contains no data), the Structure Only option is the only one available and is automatically selected
    • To import the structure of the table and the data, click Structure and Data.
    • To append the data to an existing table, click Append Data To Existing Table(s).
    Note   The import options are available only when importing an XML document. They are unavailable when importing an XSD schema file.
  7. Click OK to start importing, or proceed to the next step.
    Note   For the first two options above, if a table already exists with the same name, a new table is created with a number appended to the name. Otherwise, a new table is created.
Hope this helps you......
Reena Jain replied to s p on 21-Apr-11 01:36 AM
hi,

Here are the steps to import the .xsd file in access

  1. If necessary, open the XML or XSD file in Notepad that you want to import, and verify its data.
  2. Open the desired database and, on the External Data tab, in the Import group, click XML File.
  3. In the Get External Data - XML File dialog box, click Browse to locate the XML or XSD file.
  4. In the File Open dialog box, navigate to the folder that contains the XML or XSD file you want to import, select the desired XML or XSD file, and click Open. Select the file type All Files so that XML or XSD files will be displayed.
  5. In the Get External Data - XML File dialog box, click OK.
  6. If the file type is XML, in the Import XML dialog box, in the Import Options section, select the desired option and click OK.
  7. If the file type is XSD, in the Import XML dialog box, click OK.
  8. In the Get External Data - XML File dialog box, click Close.
  9. If necessary, open the imported table and verify its structure.
Hope this will help you
Jitendra Faye replied to s p on 21-Apr-11 08:58 AM

Here are some steps that will guide you to import XML data and schema into an access database.

* You need to open the XML or XSD file in notepad that you wish to import and then verify the data that is to be imported

* You need to open the desired database and on the external data tab and in the import group, you are supposed to click XML

* You need to click browse on the get external data* XML file dialogue box, in order to locate the XML or XSD file

* Hen you need to navigate the folder containing XML or XSD file in the filr open dialogue box, then select the file and open it

* Then click OK in the get external data – XML dialogue box

* Import the XML dialogue box, select the desired option in the import option selection and then click OK

* If the file type is XSD, then click OK

* Click OK in the get external data – XML file dialogue box

* You can open the imported table and verify the structure if the need be

for more detail follow this link-
http://www.replacelaptop.com/database/how-to-import-xml-into-microsoft-access-software-3262.html