VBA to Make a DBF File

  • Thread starter Thread starter Bob Barnes
  • Start date Start date
B

Bob Barnes

Got great code from the Excel Programming Newsgroup, but..
Thinking about trying a CSV...

Column L in the DBF is what makes the Row (Record) Unique.

Column L in the Daily Excel file is a "mixture" of Entries w/ 9 or 10
characters. I know when making a DBF Manually from Excel, that Excel looks
at the first few rows to "guess" what DataType it is, and number of
characters.

Working w/ this particular file, Excel has to be "guessing" it's 9
characters instead of the actual (example) 10 characters below.

MSR0332476
MSR0332489
MSR0332488
MSR0332486

So...the DBF results in...
MSR033247
MSR033248 --> Can't be a Primary Key
MSR033248 --> Can't be a Primary Key
MSR033248 --> Can't be a Primary Key

Is there a way to use VBA to set the number of characters
in the DBF's Column L to 10-characters?

TIA - Bob
 
Back
Top