Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Import from one database to another
I'm doing the same thing on Access and Excel. I use ADO but it can't seem to maintain the field formats/data types of the converted database. Data comes out in General format on Excel, not the way it should be (i.e. Date, Double, Integer). Since my app requires sums of the currency fields in...- Ek1mu5
- Post #11
- Forum: Visual Basic (Classic)
-
How do I initialize an ADOX Catalog?
I'm trying to convert an Access Table into an Excel Spreadsheet. The output contains a few selected fields in the Access table and has to have totals and sub-totals for the currency fields. A friend told me to use the ADOX.Catalog... Can't seem to initialize it correctly with a combobox to...- Ek1mu5
- Thread
- Replies: 0
- Forum: Microsoft: ActiveX
