Python Forum
Create a csv file that pulls data from an .accdb file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Create a csv file that pulls data from an .accdb file
#1
Photo of Attachment.accdb file Attachment1.accdb



So I have several Attachment.accdb files in my directory. I need help figuring out the correct python code to first call out to my directory and to list out all the .accdb files ONLY.

So then my output data should look something like this:
Attachment1.accdb
Attachment2.accdb
Attachment3.accdb
Attachment4.accdb
Attachment5.accdb


From there I need to figure out a way to turn my output into a variable that I can call upon later.


I then need to figure out a way to make a connection to the .accdb filse and build a list of every ReqID within the .accdb file. This list will hold all the ReqIDs from all the .accdb files.


***The ID and ReqID are from the image link shown above. If I were to open up an attachment.accdb file they consist of the following table information

In the end I will have a detailed list showing:
ID (Unique integer), ReqID, name of accdb file
ID (Unique integer), ReqID, name of accdb file
ID (Unique integer), ReqID, name of accdb file
ID (Unique integer), ReqID, name of accdb file
ID (Unique integer), ReqID, name of accdb file


I am very new to python. But am in need of great guidance and assistance.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Create Choices from .ods file columns cspower 3 518 Dec-28-2023, 09:59 PM
Last Post: deanhystad
  file open "file not found error" shanoger 8 939 Dec-14-2023, 08:03 AM
Last Post: shanoger
  Recommended way to read/create PDF file? Winfried 3 2,783 Nov-26-2023, 07:51 AM
Last Post: Pedroski55
  Create X Number of Variables and Assign Data RockBlok 8 869 Nov-14-2023, 08:46 AM
Last Post: perfringo
  Use PM4PY and create working file thomaskissas33 0 572 Nov-14-2023, 06:53 AM
Last Post: thomaskissas33
  Create csv file with 4 columns for process mining thomaskissas33 3 691 Nov-06-2023, 09:36 PM
Last Post: deanhystad
  Better python library to create ER Diagram by using pandas data frames as tables klllmmm 0 986 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  Input network device connection info from data file edroche3rd 6 912 Oct-12-2023, 02:18 AM
Last Post: edroche3rd
  Need to replace a string with a file (HTML file) tester_V 1 698 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  How can I change the uuid name of a file to his original file? MaddoxMB 2 868 Jul-17-2023, 10:15 PM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020