troubleshooting Question

import txt file into access vba

Avatar of drtopserv
drtopservFlag for Israel asked on
Microsoft AccessVisual Basic Classic
15 Comments1 Solution1093 ViewsLast Modified:
I have a txt file :
000123456;1;0000000000000000;00555;2009/08/07;0000000999;1;1;1;YYYY/MM/DD;0000;
000134326;1;0000000000500000;00655;2005/08/04;0000000889;1;1;1;YYYY/MM/DD;0200;
without a headers.
i need to import this file from \\srv09\import\list.txt into access through VBA , by i  need to maintain the size of the fields (means first contain ID i need to import it with all the zeroz and so on.
also i need to import it to an exist table that have a fields name.
 
ASKER CERTIFIED SOLUTION
itcouple

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros