SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Read / Write Visal Foxpro Data by SAS

Regular Learner
Posts: 1

Read / Write Visal Foxpro Data by SAS

I am seeking a way of directly way of reading Visual Foxpro data in SAS, update data then write it back directly into Visual Foxpro. Using the following syntax could read Visual Foxpro data directly:

libname mylib oledb provider=VFPOLEDB.1 DataSource="H:\" preserve_tab_names=yes; However had problem on writing out data in Visual Foxpro directly using the following syntax:

data mylib.US;




ERROR: Execute error: Unable to get create accessor; Error in columns : One or more accessor flags were invalid.

ERROR: ROLLBACK issued due to errors for data set MYLIB.US.DATA.



Super User
Posts: 3,857

Re: Read / Write Visal Foxpro Data by SAS

Posted in reply to FallColor

I suggest you try SQL PASSTHRU similar to this SAS note:


Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation