<div>
Thanks! It works after a minor modification.
</div>


Thanks! It works after a minor modification.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to create mdb files on the fly with data from SQL server. I'll be getting data through ADODB.rs. When I try to create mdb file using the following syntex:<br />
<br />
Set dbDatabase = CreateDatabase(sNewDBPathA<wbr />ndName, dbLangGeneral, dbEncrypt)<br />
<br />
For Each fld In rs.Fields<br />
&nbsp; &nbsp; Set fldArray(i) = tdLogTable.CreateField(fld<wbr />.Name, fld.Type, fld.DefinedSize)<br />
&nbsp; &nbsp; i = i + 1<br />
Next<br />
<br />
the program error out at the table.CreateField method. The &quot;fld.Type&quot; returns an ADODB.rs.field type which can't be recognized by the CreateField method. Can anyone show me how to solve this? Thanks in advance! <br />

</div>
</div>


Hi,

I need to create mdb files on the fly with data from SQL server. I'll be getting data through ADODB.rs. When I try to create mdb file using the following syntex:

Set dbDatabase = CreateDatabase(sNewDBPathAndName, dbLangGeneral, dbEncrypt)

For Each fld In rs.Fields
    Set fldArray(i) = tdLogTable.CreateField(fld.Name, fld.Type, fld.DefinedSize)
    i = i + 1
Next

the program error out at the table.CreateField method. The "fld.Type" returns an ADODB.rs.field type which can't be recognized by the CreateField method. Can anyone show me how to solve this? Thanks in advance! 


How to convert ADO.rs.field.type to DAO.rs.field.type?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.