Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrmike
Starting Member
2 Posts |
 Posted - 2004-06-03 : 14:27:28
|
| Does anyone know of a commercial/free control or library that allows the programmer to control importing data into an Access table from VBA (within Access)? I want the control to allow the user to graphically match up table fields and import fields, specify default values, etc. Ideally, the control should have events that allow me to handle errors, wrap the whole process in a transaction, etc.I've spent a good bit of time looking on Google, etc., and I can't seem to find a product that does this (even for standalone VB.) I could write my own, but I can't afford the time.Note: this is within a standalone Access-based product that uses the run-time engine, so that the Access database and wizards, etc. are not available, and,even if they were, I (the programmer) want fairly full control of what the user sees and is allowed to do. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-06-07 : 13:01:36
|
| Doesn't SQL's DTS work with Access? Sam |
 |
|
|
|
|
|
Access import