Search results

There will only be a few users (Under 10), security is not really an issure, and as for size... I would guess around 6 million records/season. Not very big, Access would be able to handle it!! The text file size would be (this is just a guess) under 100 mb's/year. This will grow as time goes...

Hi, I'm going to be setting up a database using SQL server and having Access operate the front end. Would you suggest using SQL server Personal or Standard? What are the differences? Thanks for your input!!

How do you import it as one field? It was a comma delimeted file. There are no periods so it should work as is.

Thanks for all of your solutions!!!

Hi, I am trying to import a txt file into Access. It all works fine except for the Time column won't import. It's separate from the Date column. I classified it as Date/Time but it won't import. There is a.m. and p.m. at the end of each time. Does that mean that I have to import it as text...

I'm drawing a blank here, all I want to do is a simple query on a table. I have a column of codes such as VGH, TRJ, ISK, etc. There are anywhere from 10 to 100 of each code. I want to find out how many different codes there are. I'm sure this is very simple to do!!!

Hi Namliam, O.K., maybe I just need a little bit of help getting started here!! It's hard to learn this stuff when you don't even know where you should be starting!!!

Hi Namliam, Thanks for the offer and for the help!! I want to try to do this on my own, I have to learn how to do stuff like this somehow!! I'll let you know how I make out in a few days and I might take you up on your offer if I'm just not getting anywhere. Thanks again!!

Hi Fofa, I also need each record from every file to be named the same (in an extra column) as the folder that it came from. Thanks for your response!!

Hi, I'm trying to do something here in Access and I'm not sure if it's possible. I want to take 165 txt files and merge them together in Access. They are all in their own folder with the same filename. They are created daily and will have 24 records each. How can I go about doing this...

:confused: Hi, I'm trying to do something here in Access and I'm not sure if it's possible. I want to take 165 txt files and merge them together in Access. They are all in their own folder with the same filename. They are created daily and will have 24 records each. How can I go about doing...

I think I know what you mean, could you expand on that a little more though?

I need to bring them all in at once. These are hourly values from a series of weather stations. We use them to predict disease outbreaks for the agriculture industry. I would like to keep updating each stations file daily so they're always up to date. I was linking tables at first to the txt...

Hi, I have 160 txt files that I want to bring into Access to run different models on and do reports with. These files are updated daily using a different program. The only way to tell the difference in them is their filename. The column headings are the same and the data is all of the same...

Hi, Whenever I try to make changes to a linked table I get an error message from Access saying that is not allowed in this ISAM. I was curious as to what this ISAM is?? Thanks

I like the idea of importing 1 txt file that has all of the data in it, but unfortunately I can't do that. The software that I use to acquire the data won't let me do that and get hourly data. In order to get hourly or 15 min. data I have to do each station separetely. This works fine, and I...

The tblStations table makes perfect sense but I have questions about the tblEvents. Eventually, I'm going to want the database to automatically update all 150 stations with the daily weather files and save all of the data from the beginning. This will run for approximately 2 months, every day...

Hi, I'm fairly new with Access (I've taken a few courses). I need to create a database to run a model with and am wondering what the best way to do it would be. Here is my situation. We have 150 to 200 weather stations that report data every 15 min's. I want to import this data (txt files)...