Acccess 2000 Help...

[Matt_Hirst]

Simple Access questions, I hope...

I have numerous comma seperated data files, the names of which are all in the following format ???1 to ???10 and then ???a to ???z I am looking to do a loop that will automaticly import these files into an access database. The numeric ending files are simple to do, however, how do I get the files ending in a character imported? Can it all be done with a single loop?

Second thing the files, although they are text files, don't have a file extension will this have any efffect on how to import the files?

Third thing the files all have header details, stating where they came from, then a blank line, then the field details and then another blank line is there a way to edit the files before importing to delete this header info?

Can the above be done with Access, I seem to rememeber Access 2 and 95 not having the facility to skip lines at the start of text files, or do I need to look at using something else???

regards,

Matt

 

[gemma-the-husky]

unfortunately you cant say in access
variable = "a" to "z"

but you can do this with the chr() function, which returns a chr for an integer variable

i know capital A to Z is char 65 to 90. i think the case will not be significant here.

so you can say

for index = 65 to 90
searchfile = basefile & chr(index)
etc....
next index

or even
for index = 1 to 26
searchfile = basefile & chr(index+64)
etc....
next index

hope this helps

 

[Matt_Hirst]

Thanx for the help on that...

Anyone help me out on third bit...removing the headers???


regards,

Matt