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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Can't Find The Schema.ini File    
 
   
RioBob
post Oct 2 2014, 09:55 AM
Post#1



Posts: 19
Joined: 30-September 06
From: Florida


Hi All,
I'm tasked with editing someones work and hit a snag, I can't find the Schema.ini file used to make the TransferText function work.
Everything works as it's supposed to, see below, however we have to implement a design change so the "Import_Specs" requires some minor changes.
DoCmd.TransferText acImportDelim, "Import_Specs", "tbl_Import_Temp", FilePath, True, ""
If I remove "Import_Specs" the transfer fails.
The Schema.ini file is not in the local directory on on this workstation.
Does anyone know where it might be or if it's buried in the access file/VBA code?
Thanks in advance.
RB
Go to the top of the page
 
DanielPineault
post Oct 2 2014, 11:25 AM
Post#2


UtterAccess VIP
Posts: 5,452
Joined: 30-June 11



Have you seen: http://stackoverflow.com/questions/143420/...t-specification ?
Go to the top of the page
 
RioBob
post Oct 2 2014, 01:18 PM
Post#3



Posts: 19
Joined: 30-September 06
From: Florida


Awesome !
Thank you very much.
Go to the top of the page
 
DanielPineault
post Oct 3 2014, 08:43 AM
Post#4


UtterAccess VIP
Posts: 5,452
Joined: 30-June 11



yw.gif
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    15th December 2017 - 02:27 PM