0

I'm getting errors attempting to import a csv on Windows, can someone provide the correct syntax?

I'm trying this: copy checking from 'file://C:\Users\jdoe\Downloads\testfile.csv' return summary;

and variations and get a 'SQLActionException[SQLParseException: Illegal character in authority at index 7: file://C:\Users\jdoe\Downloads\testfile.csv]

Thanks, Mark

MRB
  • 39
  • 4

1 Answers1

0

I think you need to add backslash and forward slash (and change others to forward slashes) after drive letter as per this documentation. So something along the lines of copy checking from 'file://C:\/Users/jdoe/Downloads/testfile.csv' return summary

metase
  • 1,169
  • 2
  • 16
  • 29