Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Large Array to Access (2003)
Here is a DAO example:
Private Sub CreateTable() Dim db As DAO.Database Dim td As TableDef Set db = DBEngine.Workspaces(0).OpenDatabase("c:\Temp\MyDb1 .mdb") Set td = pDB.CreateTableDef("Table1") With td 'Add fields to database .Fields.Append .CreateField("ID", dbInteger) .Fields.Append .CreateField("Name", dbText) .Fields.Append .CreateField("Points", dbDouble) db.TableDefs.Append td End With Set td = Nothing Set db = Nothing End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting large fields from Lotus approach to Excel | Excel Discussion (Misc queries) | |||
Exporting Large Array to Access (2003) | Excel Programming | |||
Transferring Large Amount of Data from Excel 2003 to Access 2003 | Excel Programming | |||
Exporting addresses from excel 2003 to outlook 2003 | Excel Discussion (Misc queries) | |||
exporting excel to csv large fields save as "####" | Excel Discussion (Misc queries) |