« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to http://axisnice.com/access-error/access-error.php

Reinstalling Windows will erase everything from your hard drive, allowing you to start again with a fresh system. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Follow the steps in the Wizard to choose a restore point. Are you aComputer / IT professional?Join Tek-Tips Forums!

I have tested the mask called IMP_CA_Worx and the mask is working. And more importantly what can i do about it? How is the Gold Competency Level Attained?

Get 1:1 Help Now Advertise Here Enjoyed your answer? The line is: DoCmd.TransferText acImportDelim, "importProjects", "Projects", thisFile, False Now that I'm about to install the same db in Access 2000 I get problems. You cannot import this file PHV (MIS) 25 Mar 13 14:28 What is the value of Me!txtFile ? We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved.

These troubleshooting steps get progressively more difficult and time consuming, so we strongly recommend attempting them in ascending order to avoid unnecessary time and effort. Click Add or Remove Programs. So, any way of making the transfertext command accept a non-.txt file? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. Join Us! *Tek-Tips's functionality depends on members receiving e-mail.

Step 8: Install All Available Windows Updates Microsoft is constantly updating and improving Windows system files that could be associated with Error 31519. Member Login Remember Me Forgot your password? In the Registry Editor, select the Error 31519-related key (eg. Maintaining a driver backup provides you with the security of knowing that you can rollback any driver to a previous version if necessary.

Already a member? http://windowssecrets.com/forums/showthread.php/88433-Error-31519-Cannot-Import-file-(WIN-XP-Access-2003) Operating System Information 31519 error messages can occur in any of the following Microsoft Windows operating systems: Windows 10 Windows 8 Windows 7 Windows Vista Windows XP Windows ME Windows 2000 Without any context or reference point that last bit makes no sense to me at all. 'Allowing the user to select the text file' is not any part of the question Click on the Microsoft Access-associated entry.

One I ran into was that my CRM would export the query results as a file with an .xls extension. this website je 0 LVL 38 Overall: Level 38 MS Access 26 Message Accepted Solution by:Jim P.2014-04-21 Because I know the file I'm importing from is going to be an HTML/XML file The file is then saved with a .reg file extension. I recognise Quality when I hear it Ron_dK View Public Profile Find More Posts by Ron_dK 10-18-2007, 09:39 AM #3 Beady Registered User Join

If you are not currently backing up your data, you need to do so immediately (download a highly-recommended backup solution) to protect yourself from permanent data loss. Afetr converting the db to 2002, the transfertext command fails with a "31519 Cannot import this file". jaredvsView Member Profile Apr 7 2007, 04:09 PM Post#9Posts: 91Joined: 25-September 03any ideas on this last one??? http://axisnice.com/access-error/access-error-75.php Solved Transferspreadsheet 31519 error Posted on 2014-02-27 MS Access 1 Verified Solution 12 Comments 545 Views Last Modified: 2014-04-25 I am trying to import an Excel .xlsx file into Access using

Cleaning up these temporary files with Disk Cleanup might not only solve your 31519 error, but can also dramatically speed up the performance of your PC. I only included one for this example: .datCODEPublic Function fImportNonTXTFiles(strImportFile As String, strImportSpec As String, _strDestinationTable As String)On Error GoTo errHandlerDim FLength, Fext, FOrig' FOrig holds the file's original name' The You will be prompted with a permission dialog box.

One of my clients downloads a file every day from their vendor portal, and uses a utility I created to import that file into their database.

RE: Error 31519. All rights reserved. How to run Disk Cleanup (cleanmgr) (Windows XP, Vista, 7, 8, and 10): Click the Start button. After you have successfully uninstalled your Error 31519-associated program (eg.

If you're still not sure which parameter is which in the DoCmd.TransferText() then it would be the fourth parameter and it's called FileName. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. In the results, click System Restore. see here Similar Threads transfer text macro Ana, Oct 9, 2003, in forum: Microsoft Access External Data Replies: 1 Views: 266 Ken Snell Oct 10, 2003 transferspreadsheet too many fields, but not with

To run System File Checker (Windows XP, Vista, 7, 8, and 10): Click the Start button. Click Programs. Sign Up Now! The following is what I have: Expand|Select|Wrap|Line Numbers PrivateSubCommand43_Click() DimfDialogAsOffice.FileDialog DimvarFileAsVariant DoCmd.SetWarningsFalse 'SetuptheFileDialog SetfDialog=Application.FileDialog(msoFileDialogFilePicker) WithfDialog .AllowMultiSelect=False .Title="SelectaTextFiletoImport" .InitialFileName="C:\*.txt" 'ClearoutanyFilters,thenAddyouown(1) .Filters.Add"TextFiles","*.TXT" 'ShowtheDialog.IftheShowMethodreturnsTrue,theUserpicked 'atleast1File,otherwisetheUserclickedCancel If.ShowThen ForEachvarFileIn.SelectedItems 'Therewillbeonly1Fileselected,soplacetheproperArgumentsintotheTransferTextMethod DoCmd.TransferTextacImportFixed,"ImportB","B",0 Next

The time now is 09:10 PM. I appreciate any help or direction, thanks. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. Right click the file and do an Open With and select Notepad and see what it looks like in the guts. 0 LVL 46 Overall: Level 46 MS Access 46

Click Programs and Features. Thanks __________________ Regards Bernard D Beady View Public Profile Visit Beady's homepage! Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. A black box will open with a blinking cursor.

jaredvsView Member Profile Apr 7 2007, 03:16 PM Post#7Posts: 91Joined: 25-September 03Ok I found another work around... If you're having a computer problem, ask on our forum for advice. I managed to get around it by saving the .xls as a .csv file -- and the transfertext option works. Please ( LoginorRegister )

Custom Search UtterAccess Forums>Microsoft® Access>Access Modules Error importing data...

Click on the Microsoft Access-associated entry. Because I know the file I'm importing from is going to be an HTML/XML file I came up with this code to convert it to a true XLS file. (CODE) It