H
hope
Hi All
Access 97
I just cannot get my head round this problem, so came back to the good old utter access for help
1...I have got a data base that I'm making for a karaoke song book.
2....I have a program that exports the songs out in a xxxx.csv format.
3....Now I have put code in like this
=============
Start of code
Option Compare Database
Option Explicit
---------------------------------------
' testimport
'------------------------------------------------------------
Function testimport()
On Error GoTo testimport_Err
DoCmd.TransferText acImportDelim, "", "AllTracks", "C:\import\AllTracks.csv", False, ""
testimport_Exit:
Exit Function
testimport_Err:
msgbox Error$
Resume testimport_Exit
End Function
End of code
========================================
Which works find upto a point.
The program that exports the xxx.csv file makes BLANK fields in it like this
song.......blank.......Artist......blank........label......blank......track......blank.......folder
So is there any way that I can do this?
1.....Take out the blanks befor inport ( I know I could inport into excel but that would be no good)
2......Make a delete query after inport into table that would look for blank fields and delete them.
3......Or any other way of getting rid of the blank fields.
Or am I going the wrong way to do this?
Object of thie data base is this
To make a song book of all my karaoke files . I know I can get programs that do this BUT I want it
for this karaoke program that I have got.
1....Once the program as made a data base of the songs I can export it as a xxx.csv file
2....Import that file into my access data base.
3....If the table as got data in it then it would delete that data and put in the new data.
(the reason for this is that the karaoke program makes a NEW export file every time with ALL new songs.
4.....I then can make a report for printing out a song book for the singers.
Hope I have made my self clear on all of this.
BTW if you know of anyone who as done this in Access Please could you let me know
Many thanks for your time
As always, any and all help is greatly appreciated.
Thank you in advance.
John
Access 97
I just cannot get my head round this problem, so came back to the good old utter access for help
1...I have got a data base that I'm making for a karaoke song book.
2....I have a program that exports the songs out in a xxxx.csv format.
3....Now I have put code in like this
=============
Start of code
Option Compare Database
Option Explicit
---------------------------------------
' testimport
'------------------------------------------------------------
Function testimport()
On Error GoTo testimport_Err
DoCmd.TransferText acImportDelim, "", "AllTracks", "C:\import\AllTracks.csv", False, ""
testimport_Exit:
Exit Function
testimport_Err:
msgbox Error$
Resume testimport_Exit
End Function
End of code
========================================
Which works find upto a point.
The program that exports the xxx.csv file makes BLANK fields in it like this
song.......blank.......Artist......blank........label......blank......track......blank.......folder
So is there any way that I can do this?
1.....Take out the blanks befor inport ( I know I could inport into excel but that would be no good)
2......Make a delete query after inport into table that would look for blank fields and delete them.
3......Or any other way of getting rid of the blank fields.
Or am I going the wrong way to do this?
Object of thie data base is this
To make a song book of all my karaoke files . I know I can get programs that do this BUT I want it
for this karaoke program that I have got.
1....Once the program as made a data base of the songs I can export it as a xxx.csv file
2....Import that file into my access data base.
3....If the table as got data in it then it would delete that data and put in the new data.
(the reason for this is that the karaoke program makes a NEW export file every time with ALL new songs.
4.....I then can make a report for printing out a song book for the singers.
Hope I have made my self clear on all of this.
BTW if you know of anyone who as done this in Access Please could you let me know
Many thanks for your time
As always, any and all help is greatly appreciated.
Thank you in advance.
John
)