Re: Importing multiple files..

Thanks for the response. Neither worked. The code was ok until the file
changed. The file changed (not the name) from a comma delimited to a tab
delimited. I tried even changing the extension to a *.txt and that did not
work. I have also changed the specifications in "Genetics Imports" and nodda.
... :(

MGFoster wrote:
Hello,
I have to import monthly, files that were once *.csv but due to commas in
addresses, the interface program was changed to dump tab delimited. Now my
code is not finding the files in the folder? The code is below - can anyone
help? (The files still are named with the extension of *.csv)
<SNIP>
' the pathname of the folder that contains the files for import
strInputDir = "S:\Council\APPS\GENETICS\CURRENT\"
<SNIP>
strImportFile = Dir(strInputDir & "\*" & strFileExt)
Set db = CurrentDb
<SNIP>

The path name has 2 \ characters after the concatenation:

S:\Council\APPS\GENETICS\CURRENT\\*.csv

Change this:

strImportFile = Dir(strInputDir & "\*" & strFileExt)

to this:

strImportFile = Dir(strInputDir & "*" & strFileExt)

Or, change this:

strInputDir = "S:\Council\APPS\GENETICS\CURRENT\"

to this:

strInputDir = "S:\Council\APPS\GENETICS\CURRENT"


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200602/1
.

Relevant Pages

  • RE: windows update not listed in add/remove program
    ... additional program were installed .yahoo tool bar,broweser esrvice extension ... i later unistalled browser service extension fron add/remove program this ... caused the chang/remove button to dissapear office updates to dissapear in ... Click on General Tab and you will see a Button called ...
    (microsoft.public.windowsxp.general)
  • Re: Importing multiple files..
    ... unless the .csv file has been opened by an Excel program and then saved ... Can u open the .csv file using ... Have you changed the import specification to use Tab as the field ... I tried even changing the extension to a *.txt and that did not ...
    (comp.databases.ms-access)
  • Requery Total on Parent
    ... I have a form that contains ten subforms on tab pages. ... I have an item extension ... tried forcing a requery using the on change event of the item extension and ...
    (microsoft.public.access.formscoding)
  • Re: replacement for _blank (for ad system), maybe new tab?
    ... case, if he wants to open the AD in a new tab, window, whatever. ... problem is most users don't really know how to use tabbed browsing, ... That is one of the down sides of advertising for others. ... with an extension, I don't even have to see your ads. ...
    (alt.html)
  • Re: Saving the state of Firefox on hybernation
    ... hybernating a laptop, so that when you start it again, it would be ... Another option is the SessionSaver extension. ... Never looked back after finding Tab ...
    (alt.os.linux)