MS Access 2010导入规范位置? [英] MS Access 2010 Import Specification Location?

查看:87
本文介绍了MS Access 2010导入规范位置?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个MS Access数据库,其中外部数据中保存的导入具有导入作业,这些作业实际上是将某些数据从各个位置导入到某些表中.我无法确定实际上导入了哪些表以及其中存在的每个作业,因为为这些导入指定的名称不清楚且不相关.有什么办法可以找出导入实际上将数据带到哪个表?

I have an MS Access DB where the Saved Imports inside the External Data has Import Jobs which are actually importing certain data from various locations to SOME tables. I am unable to find out which tables are actually imported with each of these jobs present there as the names given for these imports are unclear and unrelated. Is there any way I could find out to which table the import actually brings the data ?

推荐答案

在外部数据"选项卡上单击保存的导入"时出现的项目将作为ImportExportSpecification对象存储在CurrentProject.ImportExportSpecifications集合中.每个对象都有一个.Name属性和一个.XML属性(以及其他属性).导入操作的详细信息位于XML数据中,例如

The items that appear when you click "Saved Imports" on the "External Data" tab are stored as ImportExportSpecification objects in the CurrentProject.ImportExportSpecifications collection. Each object has a .Name property and an .XML property (among others). The details of the import operation are in the XML data, for example

<?xml version="1.0"?>
<ImportExportSpecification Path="C:\Users\Public\zzz.csv" xmlns="urn:www.microsoft.com/office/access/imexspec">
    <ImportText TextFormat="Delimited" FirstRowHasNames="false" FieldDelimiter="," TextDelimiter="" CodePage="437" Destination="MyNewTable">
        <DateFormat DateOrder="YMD" DateDelimiter="-" TimeDelimiter=":" FourYearDates="true" DatesLeadingZeros="false"/>
        <NumberFormat DecimalSymbol="."/>
        <Columns PrimaryKey="id">
            <Column Name="Col1" FieldName="id" Indexed="YESDUPLICATES" SkipColumn="false" DataType="Long" Width="2"/>
            <Column Name="Col2" FieldName="textfield" Indexed="NO" SkipColumn="false" DataType="Text" Width="4"/>
        </Columns>
    </ImportText>
</ImportExportSpecification>

<ImportExportSpecification>元素的Path=属性指示要导入的文件的位置.

The Path= attribute of the <ImportExportSpecification> element indicates the location of the file to be imported.

<ImportText>元素的Destination=属性指定将数据导入到的表的名称.

The Destination= attribute of the <ImportText> element specifies the name of the table into which the data will be imported.

这篇关于MS Access 2010导入规范位置?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆