Oct-31-2018, 01:48 AM
The code that I get from the net will go through a loop to get all the data of ms Access.
def access(): l =[] conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\GOBOTIX\Desktop\Try.mdb;') cursor = conn.cursor() cursor.execute('select * from Try') for row in cursor.fetchall(): l.append(row) dates = [i[1] for i in l] freq1 = [i[2] for i in l] freq1 = list(map(int, freq1)) conn.close() return dates, freq1I just want to start at a certain row to lessen the time of saving the data to excel.