Meta

Maintainers

Project description

Why I created this package ?----------------------------1) One by one insertion into Access DB, But it takes too much time to insert 100k records,```python cursor.execute("INSERT STATEMENT") cursor.commit()```

2) Bulk way insertion into Access DB and it is fast if you compare with above one,But even it is very slow from https://github.com/mkleehammer/pyodbc/issues/120```python cursor.executemany("Bulk INSERT STATEMENT") cursor.commit()```But think if you want to insert 1000k records into AccessDB, how much time you have towait?

What the package will do ?--------------------------- 1) Imports the data from text file to Access Database. 2) Creating Access Database from pandas dataframe very quickly. 3) Primary Key support. 4) Can create many tables in Access Database 5) Data Types support