|
|
 |
|
|
Thread Tools | Display Modes |
Oct 22nd, 2007, 9:19 AM
|
#1 |
|
Newbie
Join Date: Oct 2007
Posts: 8
Rep Power: 0
 |
Importing a file using VB
I'm having problems with a line of code when i try to import a file using vb in access. the error is saying that it can't import file? I checked the filename in that specific directory and its there. It seems to me that its not grabbing the file period. DoCmd.TransferText acImportDelim, "SPECS", "3RPV Export", "\\Jazzs\NCC\fileNm.txt"", False, """
thanks |
|
|
|
Oct 22nd, 2007, 12:02 PM
|
#2 |
|
Newbie
Join Date: Oct 2007
Posts: 8
Rep Power: 0
|
Re: Importing a file using VB
I figured it out, thanks anyways. Appreciate the views.
 |
|
|
|
|
Oct 22nd, 2007, 2:43 PM
|
#3 |
|
Expert Programmer
Join Date: May 2005
Location: East Lansing, MI
Posts: 663
Rep Power: 4
|
Re: Importing a file using VB
Can you share your solution, in case someone has the same question in the future.
|
|
|
|
|
Oct 22nd, 2007, 2:48 PM
|
#4 |
|
Newbie
Join Date: Oct 2007
Posts: 8
Rep Power: 0
|
Re: Importing a file using VB
Dim fileDt
Dim fileNm fileDt = Format(Date, "MMDDYY") fileNm = "\\jazzs\add" & 3rpvjohndoe" & fileDt & ".txt" MsgBox (fileNm) DoCmd.TransferText acImportDelim, "SPECS", "3RPV Export", "//jazzs/add/" & "3rpvjohndoe" & fileDt & ".txt" ' DoCmd.TransferText acImportDelim, "X:\" & "johndoe" & fileDt & ".txt", False, "" ' Runs query a code to 3rpv export DoCmd.OpenQuery "UPDATE A CODE TO 3RPV EXPORT", acViewNormal, acEdit ' runs query 3RPV Qnuts DoCmd.OpenQuery "3RPV Qnuts", acViewNormal, acEdit ' Export the data to be sent to FTP DoCmd.TransferText acExportDelim, "SPECS", "3RPV EXPORT", "\\jazzs\add\fileNm.txt", False, "" |
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| problem processing file into a char array | csrocker101 | C++ | 1 | May 8th, 2007 11:50 PM |
| Importing a SWF into another Flash file | grimpirate | Other Web Development Languages | 0 | Sep 18th, 2006 12:35 AM |
| After execution - Error cannot locate /Skin File? | wchar | Visual Basic | 1 | Mar 5th, 2005 9:04 PM |
| airport Log program using 3D linked List : problem reading from file | gemini_shooter | C++ | 0 | Mar 2nd, 2005 4:12 PM |
| Structure char field to a disk file | ehab_aziz2001 | C++ | 0 | Feb 10th, 2005 2:42 PM |
Linear Mode
