Search results

hi theDBguy, i do not understand. This the same table is not the same - one is from CSV, one is from database. In CSV i have to add fields with ID to create left join like in the picture above and know what to delete fro database table, query is fast. But delete query with exists is very...

Hi, i have very simple query which is checkin if table in database has all fields from CSV (with no PK field) . If not - i am deleting them. Query looks like: SELECT tblOsServers.OsServerID FROM tblOsServers LEFT JOIN qryIm_TempOsServersDatabase2 ON (tblOsServers.ServerID =...

Hi Guys, sorry for my late answer. Wow i am grateful for providing such a nice solution. And explanation. I will implement this now and try... Let know you if is working for me. Best, Jacek

thank you CJ_London. nice to know! Best, Jacek

Hi, thank you! something else, i do not want to provide my path. I want user to get specific file from folder pointed by user. And user will point to specific folder and see csv file "OsServerRestriction.csv" because of pattern. But i do not want to provide path. User should choose folder...

Hi Guys, i have 2 tables and want to relate them. tblOsServers is coming from Excel. Generally i do not have primary key but i created composite key in tblOperatingSystems on fields: Publisher, Sku, Offer as unique. And now i have table tblOsServers. Generally one OperatingSystem can...

Cj_London, thanks! Assume that you have "E:\VnomicRep\Master_Workbook" folder path and there is your file. If you will provide initialName like above you will not see the files in this folder...Because chosen path by user is different then in InitialFileName... Jacek

Ok thank you Guys. Basically what i want to do is: 1. Allow user to select his own folder and in this folder to select file name with pattern. Arnelgp method is working only in specified path - i want to do this path dynamic and allow user to choose path. And in folder pointed by user should...

Ok thank you Guys. Basically what i want to do is: 1. Allow user to select his own folder and in this folder to select file name with pattern. Arnelgp methos is working only in specified path - i want to do this path dynamic. How to do this? Best, Jacek

Hi, i am using code like: sub test Const partialName As String = "OsServerRestriction" Const partialExt As String = "*.csv" Dim fd As Object Set fd = Application.FileDialog( _ DialogType:=3) Dim fileName As String With fd .Title = "Select " & partialName & "...

thank you Pat. I will do this. But in case of more than 15 queries to export - only solution is to use exporting recordset to txt code - am i correct? arnelgp code referring only to the situation that tables are the same with the same number of fields am i right? Best, Jacek

Pat, what do you mean by formats? I have about 15 queries with different number of columns and the same format (change decimal point and field separator only). Best, Jacek

Ok thank you Pat!!! I have to only change field separator and decimal symbol but my columns are changing - i do not have the same number of columns in each table... Best, Jacek

Ok Guys so to sum up we have only 2 solutions: 1) Add manually for each exported query spec - and have it separately and use code to run them all, like "Spec_TableName" in the loop. 2) Use code to export recordset to external txt file. Am i right?

arnelgp so your code will only also on the same spec? Best, Jacek

o wow. So arneglgp code will do not work also. Pat your method with old way will workaround this? Or i have to use sxschech code ? Jacek

Ok thank you very much! Have a nice day! Jacek

The_Doc_Man thank you very much. Nice explanation! Why arnelgp wants to use string there? Whati s purpose? I would use number as first choice? Jacek

Ok thank you. By you mean fields format? Like Number or String? And most important, the number of fields? If i have spec where i am importing 10 fields and want to use it on table where i have 2 fields - will it work? Best, Jacek

Thank you very much for help and support. And sample! CJ London are you writing these queries usin wizard or sql editor? How to learn them ?:) arnelgp nice approach. Why your method is better then one additional table? This is a matter of developer approach? Best, Jacek