Search results

Whenever I try to "Get External Data" --> "Import" using Access 2000, nothing happens. It says "Import Text Wizard" in the bottom left corner of the screen, but nothing ever comes up. I have two version of Access on my computer (97 & 2000) and this has caused some problems for me in the past...

Here's my situation. I have a .txt file that I need to bring into Access. This .txt file is set up with records that are separated by semicolons. I need to pull this information into Access and separate the data by the semicolons. I can open the file in Excel and separate the information...

Thanks for the reply... I tried the repair and compact several times, but it didn't work. I finally found the answer to the problem (I found another thread on this website that directed me to http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html. Thanks again for your reply...

I have a table with around 300 records and the last record has a #NAME in the date field. When I first try to open the table I get a error message that says "The function you entered can't be used in this expression". I hit OK and it opens the table. All of my information is in the table (and...

I want to create a macro in Access that will export an existing table into an Excel spreadsheet. The only catch is that I want the Access table to overwrite an existing "worksheet" in the Excel document, I do not want to overwrite the whole Excel file. Is there anyway to do this. Thanks for...

I have an Access Database that uses a lot of fields, and when I try to do a report to show all of my information, Access says that I have too many fields for the report. I was just wondering what the limit is on the number of fields for a report....