Thread Subject: Need help with changing the code for the Insert function

Hello everybody

I have been working on using Access as a database and then export and import data from matlab. I have a problem when I use the insert function to export data from matlab to Access. I need to control what row the data is exported to. I have copied the code for the insert function down under:

How do I change the code soo the data always is exported to row 1 in the column I export to?

How do I chose what row in the column the data are exported to?

The following threat do also describe my problem:

http://www.mathworks.com/matlabcentral/newsreader/view_thread/265597#693974


function insert(connect,tableName,fieldNames,data)
%INSERT Export MATLAB cell array data into database table.
% INSERT(CONNECT,TABLENAME,FIELDNAMES,DATA).
% CONNECT is a datbase connection handle structure, FIELDNAMES
% is a string array of database column names, TABLENAME is the
% database table, DATA is a MATLAB cell array.
%
%
% Example:
%
%
% The following INSERT command inserts the contents of
% the cell array in to the database table yearlySales
% for the columns defined in the cell array colNames.
%
%
% insert(conn,'yearlySales',colNames,monthlyTotals);
%
% where
%
% The cell array colNames contains the value:
%
% colNames = {'salesTotal'};
%
% monthlyTotals is a cell array containing the data to be
% inserted into the database table yearlySales
%
% insert(conn,'yearlySales',colNames,monthlyTotals);
%
%
% See also UPDATE.

% Author: E.F. McGoldrick, 09-02-97, C.F.Garvin, 11-13-01
% Copyright 1984-2003 The MathWorks, Inc.
% $Revision: 1.24.4.6 $ $Date: 2004/08/17 21:35:43 $%

% Check for valid connection

if isa(connect.Handle,'double')
   
   error('database:database:invalidConnection','Invalid connection.')
   
end

% Create start of the SQL insert statement
% First get number of columns in the cell array

%Get dimensions of data
switch class(data)
    
  case {'cell','double','logical'}
    [numberOfRows,cols] = size(data); %data dimensions
    
  case 'struct'
    sflds = fieldnames(data);
    fchk = setxor(sflds,fieldNames);
    if ~isempty(fchk)
      error('database:database:writeMismatch','Structure fields and insert fields do not match.')
    end
    eval(['numberOfRows = size(data.' sflds{1} ',1);'])
    cols = length(sflds);

  otherwise
    error('database:database:invalidWriteDataType','Input data must be a cell array, matrix, or structure')
   
end

% Case 1 all fields are being written to in the target database table.
insertField = '';

% Create the field name string for the INSERT statement .. this defines the
% fields in the database table that will be receive data.

for i=1:cols,
  if ( i == cols),
    insertField = [ insertField fieldNames{i} ];
  else,
    insertField = [ insertField fieldNames{i} ',' ];
  end
end

% Create the head of the SQL statement
startOfString = [ 'INSERT INTO ' tableName ' (' insertField ') ' 'VALUES ( ' ];

% Get NULL string and number preferences
prefs = setdbprefs;
nsw = prefs.NullStringWrite;
nnw = str2num(prefs.NullNumberWrite);

% Add the data for all the columns in the cell array.
for i = 1:numberOfRows,
  
  dataString ='';
  
  for j = 1:cols,
    
    switch class(data)
        
      case {'cell','double'}

        try, tmp = data{i,j}; catch, tmp = data(i,j); end %Index as cell array, or matrix, if not cell array
        
      case 'struct'
          
        try
          tmp = data.(sflds{j}){i};
        catch
          tmp = data.(sflds{j})(i,:);
        end
        
    end
    
    if isa(tmp,'double') || isa(tmp,'logical') %Test for data type.
      
      % Substitute NULL value for NullNumberWrite value
      if (isempty(tmp) & isempty(nnw)) | (~isempty(nnw) & ~isempty(tmp) & tmp == nnw) | (isnan(tmp) & isnan(nnw))
        tmpstr = 'NULL';
      else
        tmpstr = num2str(tmp,17);
      end
      
      % Numeric data.
      if (j == cols), % Last column in the cell array.
        
        % The final comma in the field string is not required.
        dataString = [ dataString tmpstr ];
        
      else,
        dataString = [ dataString tmpstr ',' ];
        
      end
      
    else,
      
      % Character/String data.
           
      % Substitute NULL value for NullStringWrite value
      if (isempty(tmp) & isempty(nsw)) | strcmp(tmp,nsw)
        tmpstr = 'NULL';
      else
        tmpstr = ['''' tmp ''''];
      end
        
      if (j == cols), % Last column in the cell array.

        % The final comma in the field string is not required.
        
        dataString= [ dataString tmpstr];
        
      else,
        
        dataString= [ dataString tmpstr ','];
        
      end
      
    end
    
  end % End of cols loop
  
  writeString = [startOfString dataString ' )'];
  
  % Now insert the data into the database.
  cursTemp=exec(connect,writeString);
  
  if isa(cursTemp.Cursor,'com.mathworks.toolbox.database.sqlExec'),
    
    % Close the cursor.
    close(cursTemp);
  else,
    % Stop the insertion process there is a problem
    % with the SQL statement.
    
    error('database:database:cursorError','%s',cursTemp.Message);
    
    return;
    
  end
end % End of numberOfRows loop