• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

Use a SQL statement to import text files

I am currently using 'DoCmd.TransferText' to import text files using the import specifications to bring the text files into a table.  Is there a way to import text files without using the DoCmd function?
0
TBayXXXV
Asked:
TBayXXXV
  • 2
  • 2
1 Solution
 
peter57rCommented:
You could write your own file handler in VBA using the filesystemobject.

Why is transfertext a problem?
0
 
TBayXXXVAuthor Commented:
In the future, the code is going to get converted to .net and I'm told that .net doesn't support the DoCmd function.  I was asked to look for an alternative.
0
 
peter57rCommented:
.net doesn't look anything like vba.
Nothing you write will convert to .net.


0
 
TBayXXXVAuthor Commented:
I see.  Ok, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now