Solved

Use a SQL statement to import text files

Posted on 2007-11-15
4
175 Views
Last Modified: 2010-03-20
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
Comment
Question by:TBayXXXV
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 20289591
You could write your own file handler in VBA using the filesystemobject.

Why is transfertext a problem?
0
 

Author Comment

by:TBayXXXV
ID: 20289621
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
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
ID: 20289762
.net doesn't look anything like vba.
Nothing you write will convert to .net.


0
 

Author Comment

by:TBayXXXV
ID: 20290007
I see.  Ok, thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question