I am importing a worksheet from Excel. The date columns are displayed in mmm-yyyy format, though the data shows on the formula bar in mm/dd/yyyy format. ...

I setup a db system including forms and everything. I did all of my debugging in the system, but now it's time to put the db to use. Wanting a clean slate, I...

Can Excel data be imported into Access easily!? I know from Word table I can simply copy and paste but it is not that easy when doing from Excel to Access! I...

I have a table which requires updating monthly with information from 10 employees who do not have Access. In order to ensure the data remained generic I...

I hope this is the right forum for this question. I am working in an Access database and need to import data from another database, and that data is from the...

I would like to import an Excel spreadsheet into Access database--however, the spreadsheet contains hyperlinks in two columns. They are web-based links. I...

Okay I'm trying to get a table to load into another one through a series of queries. I'm am using SQL statements to do this. The name of the table that I'm...

Hi, I have a database that contains nested queries and I import these queries. That is, the database contains queries that have queries as data source (don't...

Hi, I have an excel file with phone numbers. Some are international. It is a text filed in Excel. Whenever I import them into Access, access changes...

When I import a query (which has 2 tables linked) into a blank interim database and then import from the interim database into a production database the...

Hi, I am running a query and would like the results to populate certain cells in an excel spreadsheet. Is there a way to have a field in my query be sent to a...

Hello everybody, I have two related tables: 1) Tbl_categories with fields category(Text), id (Counter and primary key), UserID (long) 2) Problems with fields ...

Hi, MY QUESTION: HOW DO I REWRITE MY MACRO so that it cycles through the 16 results of a query and uploads the 16 resulting text files to my database in one...

We have a template Access Database with all relationships created. Queries are running off of these relationships. The data is being imported weekly from...

Hi all, I'm using an SQL statement like below to import data from a comma delimited text file. "tblImport" has all fields set as a text data type. I've found...

Hello there I need to build a complex query which have relationships from 4 tables. and this query must be updatable. Because the data on the tables is very...

I have a linked table (MS Excel spreadsheet) that I use to update current records and import new records into my database. I have two fields in my table that...

....I'm sure it's possible. I have a table that shows each month of the year. During each month one person is assigned to complete a certain # of reviews...

Is there any way to do this? You have data that looks like this: CODE DATE OPER CASE_TYPE COLOR A 31-Aug-97 G99 T RED A 31-Aug-99 G99 T ...

Hello, I have a crosstab query in which I have Dates as the Column headings. I want the dates to appear in ascending order, and have set the Sort row to...