Search results

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!!

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, 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...

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

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)...