MS Navision SQL query to import data from flatfile in DB
This project received 25 bids from talented freelancers with an average bid price of €67 EUR.Get free quotes for a project like this
We need a query that automaticly (e.g. every day at 4pm) imports data from a [url removed, login to view] in our db (ms sql) with:
> fieldterminator ";" and
> rowterminator "\n"
If the row exists in table then not overwrite
If its an new flatfile then make an empty row
> After import is done, rename [url removed, login to view] in [url removed, login to view] or move the file into a subfolder
Thats in short. Is this possible?
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online