Possible Bug on importing - Urgent Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Thanks in Advanced.

Import a spreadsheet through VBA and I do not get the same order in the
table. Sometimes (Not all of the time) the first line of data might be line
59 in the table. If i run it again it might come in as line 10 then
somestimes line 1 as it is should do.

How can i keep parity.

I need to import them in the same order

I have checked Auto number is off, no hidden worksheet,

I need you help please.

Thanks

Trev
 
Not a bug. In any relational database, not just Access, the order of records
in a table has no meaning. None. As you found out, the records can wind up in
any order. You could open the table again tomorrow and the records be in a
different order.

If you have something in the spreadsheet like a list of dates/times or
sequence numbers, you can order the imported table data in a query. In other
word, you need to set up the spreadsheet first.
 
Back
Top