baderms
Last Activity: Jun 27 '18, 12:42 PM
Joined: Jun 27 '17
Location:
-
Is the question that you want to be able to switch between typing in Arabic & English? -
You need to manually import the spreadsheet first and when doing to save the import specifications, and that's where you can tell it what columns you want to import. Then when you do the transferspreads heet command just add the specification name at the end. Perl, No. I don't know what you are referring to when you say shell script.Leave a comment:
-
What version of access are you using, if before 2016 there is a way to select the columns you want, otherwise you can import the whole thing and remove the columns you want. You can also import using all vba code.Leave a comment:
-
All three can be done, though rtf is a more complicated. For excel for example you can use the TransferSpreads heet command like this docmd.transfers preadsheet acImport, acSpreadsheet TypeExel12, "Table Name in access", "Path and File Name", true
The true here means that the first row will be column names.
for the csv you would use the TransferText.Leave a comment:
-
Put this in the click event of the button
put this into a moduleCode:Call GetFile
...Code:Public Function GetFile() As Boolean On Error GoTo Proc_Err Dim strPath As String Dim strFile As String Dim strTable As String Dim strSpecification As String Dim intImportType As AcTextTransferType Dim blnHasFieldNamesLeave a comment:
-
you also need to make sure it's in a procedure such as
public function whatever
your code
exit functionLeave a comment:
-
Have you referenced the object library. If not, from the code window select tools and select Microsoft Office xx Object Library, then it will compile.Leave a comment:
No activity results to display
Leave a comment: