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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Wizards
- Thread starter JimJ
- Start date
docmd.transfer<br>
There are 3 <br>
.TransferDatabase<br>
.TransferSpreadsheet<br>
.TransferText<br>
<br>
Depending on which tyep of file you are importing.<br>
Now the "transfer" command will allow importing as well as exporting and has lots of options.<br>
So check it out it does work well I use it alot. for both.<br>
<br>
If you type docmd. in your VBA code window and type slowly it will bring each of them up in a window<br>
<br>
Also if you have a TEXT file only<br>
you can just open it using <br>
Open "C:\myfile" for Input as #1<br>
look in help for this too.<br>
I use this if I need complete control which docmd does not offer or I have a small file.<br>
<br>
good luck<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
There are 3 <br>
.TransferDatabase<br>
.TransferSpreadsheet<br>
.TransferText<br>
<br>
Depending on which tyep of file you are importing.<br>
Now the "transfer" command will allow importing as well as exporting and has lots of options.<br>
So check it out it does work well I use it alot. for both.<br>
<br>
If you type docmd. in your VBA code window and type slowly it will bring each of them up in a window<br>
<br>
Also if you have a TEXT file only<br>
you can just open it using <br>
Open "C:\myfile" for Input as #1<br>
look in help for this too.<br>
I use this if I need complete control which docmd does not offer or I have a small file.<br>
<br>
good luck<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question