Hi All,

[hmfsurf]

Excited to deep dive into MS Access.
Need help creating a schema.ini
My data in Subset.csv is as follows:
Master,Account,Amount,Agent
3217300000000,3217300000000,5855.23,Agent/BLS
318N100106106,318N100106106,200,Agent/BLS
8310010000000,8310010000000,659.97,MNS

schema.ini
[Subset.csv]
ColNameHeader=True
MaxScanRows=0
CharacterSet=ANSI
Format=CSVDelimited
Col1=Master Text
Col2=Account Text
Col3=Amount Double
Col4=Agent Text

The result on my first 3 columns are numbers instead of having the first 2 columns to be short text.

 

[theDBguy]

Hi. Welcome to AWF!

Couple of questions:

1. Is the schema.ini file located in the same folder as the text file?
2. Have you tried using an import specification (in case we can't fix the schema.ini file)?

I thought schema.ini would normally only be used for fixed-width text files and not CSVs.

 

[pbaldy]

Welcome aboard. I moved your thread to a more appropriate forum since it has a technical question.

 

[hmfsurf]

1. yes, the schema.ini is in the same folder of the subset.csv text file. I used Format=CSVDelimited option.
2. I tried using the import specification but that would require creating a blank template to contain the import specification.
I needed a way to create a msAccess database from scratch and be able to import the CSV file into that blank database.

 

[theDBguy]

1. yes, the schema.ini is in the same folder of the subset.csv text file. I used Format=CSVDelimited option.
2. I tried using the import specification but that would require creating a blank template to contain the import specification.
I needed a way to create a msAccess database from scratch and be able to import the CSV file into that blank database.

Hi. Can you post a sample copy of your CSV file and a copy of your schema.ini file, so we can give it a try? Thanks.