J
james
Hi, I hope this is the correct forum to ask this question. I have some old
(very old) Dataflex database files that I have been able to export to XML
format files. I have been able to load those files into a dataset (VB.NET)
and display the table(s) in a datagrid.
My problem is creating a new Access Database. Well, I have done that with
ADOX, but, not with a
new table in the database (will need to create several databases files) . I
need to somehow, copy the Dataset (or contents of the datagrid) to a new
table and then copy that, along with the column headers and field
information (including the actual data) to the empty database(s).
I know that this is an Access newsgroup , but, I don't want to have to
depend on using Access (in this case Access 2000) to create the database
file(s) with the correct tables.
Does anyone have some code demonstrating how to correctly copy the table (or
dataset) structure
from the dataset or the datagrid and pass those values to a new table and
dump that into the new
database(s) ? Can the structure of a dataset or datagrid even be walked thru
and copied into a new table?
Any pointers would be greatly appreciated.
james
(very old) Dataflex database files that I have been able to export to XML
format files. I have been able to load those files into a dataset (VB.NET)
and display the table(s) in a datagrid.
My problem is creating a new Access Database. Well, I have done that with
ADOX, but, not with a
new table in the database (will need to create several databases files) . I
need to somehow, copy the Dataset (or contents of the datagrid) to a new
table and then copy that, along with the column headers and field
information (including the actual data) to the empty database(s).
I know that this is an Access newsgroup , but, I don't want to have to
depend on using Access (in this case Access 2000) to create the database
file(s) with the correct tables.
Does anyone have some code demonstrating how to correctly copy the table (or
dataset) structure
from the dataset or the datagrid and pass those values to a new table and
dump that into the new
database(s) ? Can the structure of a dataset or datagrid even be walked thru
and copied into a new table?
Any pointers would be greatly appreciated.
james