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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to Parse Imported Data String into Multiple Fields?
Problem: - I import a txt file of a directory scan on a server and need to parse the txt string into 4 fields. - There can be subdirectories in Fields2-4. - The first part of the string does have a constant "x:\Training\CourseReview\Pending Approval" This is what I would like the end result...- ETSMAN
- Thread
- Replies: 50
- Forum: Microsoft: Access Tables and Relationships
-
Update Query/New Table Query from External Data Source
Problem: Need an update query or new table query to automate external data source import for reporting purposes. Example of a record imported from an external text file. x:\Training\CourseReview\Pending Approval\TeachMeCourse\Tab A\Course101.pptx Desired Output: Update query or New Table query...- ETSMAN
- Thread
- Replies: 15
- Forum: Microsoft: Office
