Access 2007 Runtime Error 31519
Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag runtime error 31519 you cannot import this file Search Advanced Search Find All Thanked Posts Go to Page... docmd.transfertext acimportdelim Thread Tools Rate Thread Display Modes 10-30-2007, 09:56 AM #1 tingler0 Registered User Join Date: Oct 2007 Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts DoCmd.TransferText runtime error i am trying to import a CSV file into a table based on the selected date but i am getting a run-time error '2495' The action or method requires a Table Name argument. Here is my code if anyone can help. DoCmd.TransferText , acImportDelim, Contracts, "\\Zbnawlfs002\Dept\AR-Collections\CashApplications\ContractLogReport\(Se lectDate).csv", True tingler0 View Public Profile Find More Posts by tingler0 10-30-2007, 04:10 PM #2 gemma-the-husky Super Moderator Join Date: Sep 2006 Location: UK Posts: 13,110 Thanks: 50 Thanked 877 Times in 850 Posts when you enter the code, the autoprompts should offer you choices etc. Without checking, I think you may be missing parameter(s) if contracts is the name of the new table, it should be enclosed in quote marks, otherwise access looks for a variable called contracts. This may be the error gemma-the-husky View Public Profile Find More Posts by gemma-the-husky 10-30-2007, 04:18 PM #3 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts: 32,482 Thanks: 94 Thanked 1,780 Times in 1,565 Posts Quote: DoCmd.TransferText , acImportDelim, Contracts, "\\Zbnawlfs002\Dept\AR-Collections\CashApplications\ContractLogReport\(Se lectDate).csv", True Well, first of all, there is no comma after TransferText and before acImportDelim. Second, as gemma mentions Contracts would then be the import specification and it would need to be i
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting http://www.access-programmers.co.uk/forums/showthread.php?t=137873 Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules (VBA Coding) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Modules (VBA Coding) http://www.tek-tips.com/viewthread.cfm?qid=1707216 Forum Error 31519. You cannot import this file 2 thread705-1707216 Forum Search FAQs Links MVPs Error 31519. You cannot import this file Error 31519. You cannot import this file vba317 (Programmer) (OP) 25 Mar 13 12:25 I am using access 2003. I am trying to import a file and I keep on getting the error 31519. You cannot import this file. I have tested the mask called IMP_CA_Worx and the mask is working. To do the manual import I had to change the file to a text file. I copied and pasted the file name to verify I was not typing incorrectly. The name of the file is VRA03061(Gragil)_AL.C01. The file is being passed to the procedure without a problem. I have highlighted in blue where the error is. Any help would be appreciated. Tom CODEPrivate Sub cmdImp_Click() Dim strFile As String Dim boolWorx As Boolean 'On Error GoTo Err_Imp DoCmd.SetWarnings False ' Get File Name Me.txtFile.SetFocus strFile = "\\server\xfer\caf\" & (Trim(
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help https://www.experts-exchange.com/questions/27059171/doCmd-TransferText-variables-issue.html Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor https://support.microsoft.com/en-us/kb/2581495 Services Groups Website Testing Store Headlines Experts Exchange > Questions > doCmd.TransferText variables issue Want to Advertise Here? Solved doCmd.TransferText variables issue Posted on 2011-05-25 MS Access 2 runtime error Verified Solutions 6 Comments 772 Views Last Modified: 2012-05-11 I am trying to create some VBA code that will import delimited data into an Access 2007 database but am having some trouble. I am trying to use: DoCmd.TransferText acImportDelim, "Import-Car_Data", Returnvalue, blnHasFieldNames "Import_Car_data" is a saved import in the database. ( I have used a saved import runtime error 31519 so that I can specify that the import file is " delimited.) Returnvalue is a variable that has been populated with the location of the .csv import file by using a combination of the Application.FileDialog(3) and Returnvalue = .selecteditems.Item(1) code. I continually get an error stating that I "cannot import this file" Run-Time error 31519. I added some code to change the file extension of the import file from .csv to a .txt but this modification hasn't helped matters. As my import works fine when called from the GUI rather than through VBA I am very confused. Does anyone have any ideas on how I can solve tis issue? Thanks 0 Question by:JayceW Facebook Twitter LinkedIn Google LVL 119 Active today Best Solution byRey Obrero DoCmd.TransferText acImportDelim... needs the import specification NOT the "saved import steps" You need to create an Import Specification to do this automatically To create the Import Specification Go to Solution 6 Comments LVL 83 Overall: Level 83 MS Access 83 Message Active to
One games Xbox 360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft