| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
An Issue
Joel - 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from? | Excel Programming | |||
| Code to change code in a sheet and workbook module | Excel Programming | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| Code in one workbook to call code in another XL file | Excel Programming | |||
| Reference code in another workbook from a calling workbook | Excel Programming | |||
Threaded Mode
