?
Solved

Use a SQL statement to import text files

Posted on 2007-11-15
4
Medium Priority
?
180 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

752 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