PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
FilePath = "C:\Users\residents.csv" 'DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel7, "TblNm_SS", FilePath, True DoCmd.TransferText acLinkDelim, , "TblNm_SS", FilePath, True Set InRS = DB.OpenRecordset("TblNm_SS") Set OutRS = DB.OpenRecordset("PermTbl") If InRS.EOF = False Then InRS.MoveFirst Do Until InRS.EOF = True I = 0 With OutRS 'the input is an empty string write it .AddNew For I = 0 To InRS.Fields.Count - 1 .Fields(I).Value = CStr(Nz(InRS.Fields(I).Value, "")) Next I .Update End With InRS.MoveNext Loop End If
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Reports issues going from Access 2003 to Access 2013||14||68|
|How To Overlay Combo Box Row Source Type 'Value List' From VBA||2||49|
|Want my table columns to autofit.||7||58|
|Ms Access 2010 Setup (Executable file)||4||64|
Join the community of 500,000 technology professionals and ask your questions.