Search results

Thanks ! this works I was running wrong way, thanks a lot arnelgp

Hello I have one database which is runs every week from windows scheduler to perform some import functionality from CSV files. However I would like to run one another activity which should be done in every six month ( twice in year ), this is also import functionality. I was wondering how...

Thanks, this seems to be good, but it does not work for me. It does not add record to tbl_deletedBasics. Consider I have table called tbl_PilotBasic with all import from CSV file.

You seems to be right, how do I achieve that problematically.

Hi I have below code where Sub compareCSV(filename As String, tablename As String, deletetablename As String) Dim rs As DAO.Recordset Dim file_number As Integer Dim raw_line As String Dim csv_line As Variant Set DB = CurrentDb() file_number = FreeFile Open filename...

But I can not go everytime and modify csv file because it is automated process, the files are being saved from PowerShell and unziped in it. and they are being used in Access. Thanks

Thanks a lot for this. But still I need small help Can you please list out steps like what steps has to be performed first and all My query is that import has to happen from CSV to table in Access table and then mechanism to delete the records which are there in existing table but not there...

hello I am using below code to do csv import DoCmd.TransferText acImportDelim, tableName:="tbl_Basic", _ FileName:="C:\Download" & "CS" & getMonth & "" & CStr(getYear) & "\PILOT_BASIC.csv", HasFieldNames:=True itdoes works well but also adds one extra column in table tbl_Basic at the end...

If RecordFound = False Then DB.Execute "INSERT INTO tbl_DeletedBasic ([UNIQUE ID],[FIRST NAME],[LAST NAME],[STREET 1],[STREET 2],CITY,STATE,[ZIP CODE],COUNTRY,REGION,[MED CLASS],[MED CLASS],[MED EXP DATE])SELECT * FROM tbl_NewBasic where [UNIQUE ID] =" + field_value End If I am...

Here is the attached database and Csv file but please remember the import process has to be done using VBA.

Can you simplify for me above steps. ?

What I was thinking is that first I will write function in VBA to check from existing table [taking unique id as reference ] and then go to CSV file, check if that unique ID does not exists copy that recrod from table and paste it to deletedtracker table. if exists dont do anything. Will write...

I would like to import CSV file into MS access using VBA, this import would import new records from CSV ( with unique ID ) and delete the records in the destination access table which is not there in incoming CSV. ( by Unique ID ) For example if table in access has records unique ID = A232122...

Hello I would like to encode incoming url to base 64 if it contains query string ( i.e after ? mark parameter ) as enrollmentnumber" okay so incoming url would look like this index.php?enrollmentnumber=1234 if incoming url contains enrollmentnumber then convert anything after question mark (...

These are being shape data and I have been told to find out latitude and longitude out of that, and these data will be fed to Tableau for visualization purpose.

Here it goes. thanks for your immediate reply. IndexObjecID MinGx MinGy MaxGX MaxGY 1 323129212 323221911 582437433 434928221

Hello I have been given some parameters like minx and miny axis for mininum and maximum and have been told to find out longitue or latitude out of that. Could anybody please tell me how to find out longitude or latitude for given four parameters, is there any formula or is there any api i...

Hi All I would like to have screen caputring utility in ms access where in user would click on button on ms access form to caputre any image, be it on web site or wherever on the screen, and then it should save in attachment data type field on the form. Please assist me if this is possible...

I did not quite understand what do you mean. I have three tables called tbl_wholesalers, tbl_retailers and tbl_suppliers. These three tables are having identical columns except tbl_supplier will have supplier type as a column. tbl_wholesalers and tbl_retailers are part of subform and display...

I have two different datasheet view/tables called wholesalers and retailers [part of subforms] on the form. Now I have one tables which is combination of front end tables [as said above ] when user enters data in the wholesalers datasheet view of the form it should do entry in the supplier...