New to Access

[cmbruce22]

Am new to Access -using 2013. Goal is to import a file into access table and produce a file for a template to load into another system (export to Excel).



Have table of data - would it be best to create query with the required output fields or a report? There will be many fields in the output report which will be blank but must have the field included to import into the other system.

[June7]

A query probably adequate for the situation.

What file are you importing into Access? The 'other system' is Excel?

[cmbruce22]

Am importing Excel with some of the output fields - how do I add fields to a query which are not in the connected table?

The import Excel files has 39 columns whereas the output will have 52 columns. The additional columns will need the headers and be in a specific format.

[June7]

Create fields in query with an expression, example:

SELECT field1, field2, Date() AS fieldW, Null AS fieldX, 0 AS fieldY, "N/A" AS FieldZ FROM tablename.