|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
|
|||
|
|||
|
Hello:
I have an Access database program that I originally wrote and was improved by an intern who now is gone. I am attempting to add several new fields to a table via a download of info from an existing program in the form of a text file. The additional fields will not add to my Access table. I can open the text file in Excel and the new fields are present. I am looking for help in understanding the Specification Name (in red below). ?? Is this specification name in some way defined somewhere and will not allow these new fields?? Is there somewhere else I should looking? Is the delim type causing problem Thanks John Brenner 814-207-3860 (Cell) Private Sub Command9_Click() If Check1 = True And Check3 = True And Check5 = True Then Dim file As String file = InputBox("Enter the name of the file created from the report ShipDateAnalysis under the user name JohnB in Babylon. Do not include .txt extension.", "Enter Filename") DoCmd.DeleteObject acTable, "Date1" DoCmd.TransferText acImportDelim, "DATE1_IMPORT", "Date1", "C:\My Documents\" & file & ".txt", True DoCmd.DeleteObject acTable, file & "_ImportErrors" DoCmd.Close acForm, "ImportDate1", acSaveNo Else: MsgBox "Complete all steps listed before import.", vbOKOnly, "Complete steps" DoCmd.Close acForm, "ImportDate1", acSaveNo End If End Sub |
|
#2
|
|||
|
|||
|
Import wizard Advanced button
Hi:
I figured it out. For those interested I was able to modify the Specification name "Date1_Inmort" in the Import external data wizard area of Access by clicking on the advanced button during the import. I now have the extra variables I want in my table. Now the real fun begins. This is an interesting site. I have learned much in the last few days, I hope this will be of use to me in the future. |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Transfer text problem adding fields |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|