• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Get index of a row

 
dushantha Rathnayake
Ranch Hand
Posts: 103
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

My client has a MS Access database. Using this database I have to build a application. But I want to use Mysql database. So I have to get data from MS Access database. The problem is, In this MS Access tables there are no any Primary Keys. So I can't capture data correctly. But I have an idea about table row number. If I can get the index numbers of that rows I can capture them correctly. If anyone know about how to get the table row index number please tell me.

Thank you.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33671
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Row numbers are a horrible way of tracking things - they can change when you reorganize your database. To change databases, you can do an export of the table to CSV.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic