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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
export to text file
Hey guys, That's a TON of code........why not put your functions trim & pad with spaces) into a query.......each field as needed and then when you've got your text formatting all set do a simple docmd.transfer text,delimited destination file? Just food for thought (and I HATE to type mounds...- KippL
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
importing from excel - losing data
Mark, Here is my guess.........when access is creating a table to store your data in it "sees" the characters "ID" in a field name.....assumes it's a KEY field and doesn't allow duplication......you need to pre-design an empty table in access and set all field data type...- KippL
- Post #2
- Forum: Microsoft: Access Other topics
-
Importing from Excel - losing 3rd level
Mark, Here's my guess......(Any field name in an access table with "ID" in it will almost always get set up an indexed field (most will not allow duplication by default) so if you have duplicate information in this field in your xl data this will generate the first error....your second...- KippL
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
