Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Can't import csv data
#3
(Sep-16-2022, 10:43 AM)JonWayn Wrote: But then when I go to import this file into a Microsoft Access database, nothing is imported.

It's been a number of years since I worked with MS Access, but from what I can recall: make sure that the separator is set to comma, and not some other separator. Also, I think I remember a setting that tells Access if the first row contains the header information. If not, the table will be created with default header names, which you can, of course, edit, post import.
Sig:
>>> import this

The UNIX philosophy: "Do one thing, and do it well."

"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse

"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
Reply


Messages In This Thread
Can't import csv data - by JonWayn - Sep-16-2022, 10:43 AM
RE: Can't import csv data - by buran - Sep-16-2022, 11:01 AM
RE: Can't import csv data - by JonWayn - Sep-18-2022, 02:01 AM
RE: Can't import csv data - by rob101 - Sep-16-2022, 09:28 PM
RE: Can't import csv data - by JonWayn - Sep-18-2022, 02:07 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Plot a pandas data fram via pyqtgraph with an modul import and qt designer widget Nietzsche 0 879 May-29-2023, 02:42 PM
Last Post: Nietzsche
Video doing data treatment on a file import-parsing a variable EmBeck87 15 3,036 Apr-17-2023, 06:54 PM
Last Post: EmBeck87
  Python 3.11 data import question love0715 2 845 Mar-05-2023, 06:50 PM
Last Post: snippsat
  I try to import data from Excel table to Word Template. NewbiePyPy 0 3,322 Oct-21-2020, 12:25 PM
Last Post: NewbiePyPy
  Import CSV data into array and turn into integers DoctorSmiles 5 3,296 Jul-16-2020, 10:47 AM
Last Post: perfringo
  How to import data to excel jkessous 4 2,990 Jan-26-2020, 07:53 PM
Last Post: snippsat
  Early data import question VorpalPirate 2 2,290 Dec-09-2019, 10:52 PM
Last Post: snippsat
  How to import data from database to excel nick123 1 3,552 Oct-09-2019, 04:39 PM
Last Post: sm51251
  Import data from excel to Teradata steve87bg 3 4,801 Sep-18-2019, 01:36 PM
Last Post: steve87bg
  Import and/or read IMC measurement data Squipy 0 3,812 Aug-11-2019, 02:48 PM
Last Post: Squipy

Forum Jump:

User Panel Messages

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