Hi everyone,
I have a excel file in which there is an "End of File" character in the last row.
I am trying to import this excel file in to my sql server table but it gives error until I manually open file and removes the character.
What I want is to automate the process of downloading the file from source and deleting or removing the last row and import the file in table of SQL.
I am only stuck at deletion of this character, rest steps I have already automated.
Can anyone please guide me how can I do it? I tried removing via batch file and using macros but unsuccessful so far.
The file can be downloaded from here:
https://www.treasury.gov/ofac/downloads/sdn.pip
I have a excel file in which there is an "End of File" character in the last row.
I am trying to import this excel file in to my sql server table but it gives error until I manually open file and removes the character.
What I want is to automate the process of downloading the file from source and deleting or removing the last row and import the file in table of SQL.
I am only stuck at deletion of this character, rest steps I have already automated.
Can anyone please guide me how can I do it? I tried removing via batch file and using macros but unsuccessful so far.
The file can be downloaded from here:
https://www.treasury.gov/ofac/downloads/sdn.pip