UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Csv Import Issue, Access 2016    
 
   
ecovindaloo
post Nov 13 2019, 03:55 PM
Post#1



Posts: 309
Joined: 1-November 08
From: New York Area, USA


I have an Access front end with a MySQL backend. I'm trying to import csv files into a local Access table.

The csv file used the tab as a delimiter. Because of this I created a Saved Import and use it in a line of code.

This is the code:
DoCmd.TransferText acImportDelim, "CSV_FileImportOffice", "tmpCSV_NewLeadsImport", arrXL_Files(i), True

CSV_FileImportOffice is the name of the saved import.

The issue is that when I run the code I get an error message saying that the CSV_FileImportOffice can't be found. I'm able to manually run this saved import with no problem.

I also closed and reopened Access and still get the same error message.

Any idea why the code isn't working? Or is there a workaround for this type of issue?
Go to the top of the page
 

Posts in this topic
- ecovindaloo   Csv Import Issue   Nov 13 2019, 03:55 PM
- - theDBguy   Hi. I think you're using the wrong code. Try: ...   Nov 13 2019, 04:21 PM
- - ecovindaloo   I created two import two saved imports one for my ...   Nov 13 2019, 04:54 PM
- - theDBguy   Hi. But, did you try my suggestion? Just curious.....   Nov 13 2019, 05:01 PM
- - ecovindaloo   I won't be able to try until tomorrow when I c...   Nov 13 2019, 05:07 PM
- - theDBguy   I haven't, but I have seen it before. There...   Nov 13 2019, 05:08 PM
- - ecovindaloo   In the big picture what I'm trying to do is th...   Nov 13 2019, 05:12 PM
- - theDBguy   Hi. You can probably use Freefile() to do it, but ...   Nov 13 2019, 05:15 PM
- - ecovindaloo   I was debating about using FreeFile. I haven...   Nov 13 2019, 05:25 PM
- - theDBguy   QUOTE (ecovindaloo)That's why I was hoping tha...   Nov 13 2019, 05:27 PM
- - ecovindaloo   I'll try it tomorrow and let you know what hap...   Nov 13 2019, 05:35 PM
|- - theDBguy   Okay. It should work; but if not, we'll help y...   Nov 13 2019, 05:36 PM
- - ecovindaloo   Will your suggestion when I'm importing differ...   Nov 13 2019, 05:36 PM
- - theDBguy   Hi. The code I gave you executes a "saved imp...   Nov 13 2019, 05:39 PM
- - ecovindaloo   I'll try creating an import spec tomorrow and ...   Nov 13 2019, 07:05 PM
- - theDBguy   Okay, if you create an import spec, then you'l...   Nov 13 2019, 07:49 PM
- - ecovindaloo   I dialed into the client and things still aren...   Nov 14 2019, 02:59 PM
- - theDBguy   Hi. Did you try the code I suggested? If so, what ...   Nov 14 2019, 03:21 PM
- - WildBird   I've worked with a lot of CSVs, and as long as...   Nov 14 2019, 03:35 PM
|- - theDBguy   QUOTE (WildBird)I've worked with a lot of CSVs...   Nov 14 2019, 03:38 PM
|- - WildBird   QUOTE Hmm, but doesn't TransferText "requ...   Nov 14 2019, 06:39 PM
|- - theDBguy   Ah, it's optional for delimited files because ...   Nov 14 2019, 08:22 PM
|- - WildBird   QUOTE Ah, it's optional for delimited files be...   Nov 14 2019, 08:50 PM
|- - ecovindaloo   Here's the function I created to be able to op...   Nov 15 2019, 10:50 AM
|- - theDBguy   Hi. Congratulations! I'll make sure to poi...   Nov 15 2019, 12:32 PM
|- - ecovindaloo   Thanks. And thanks again for all the help.   Nov 15 2019, 12:44 PM
|- - theDBguy   Hi. You're welcome and thanks for sharing!   Nov 15 2019, 12:49 PM
- - ecovindaloo   I'm still getting the error message that the i...   Nov 14 2019, 03:38 PM
- - ecovindaloo   Here's where things are at now: I pasted the ...   Nov 14 2019, 04:53 PM
- - theDBguy   Hi. You didn't answer the second part of my qu...   Nov 14 2019, 04:58 PM
- - ecovindaloo   The name of the saved import I used in the code wa...   Nov 14 2019, 06:21 PM



Custom Search


RSSSearch   Top   Lo-Fi    2nd July 2020 - 05:00 AM