Search results

Hi, I'm running an Append Query from an Excel <linked> file to a table in access. From what I can tell, the first filed is overflowing with a linked filed numeric of 'Double'. You can't change linked table fields. However when I first link the Excel file, the Append works... :D only when I...

I update, import and export tables, problem is I need a way to track what I have done or allow someone to pick up where I left off. Is there a way for MS Access to return the Create or Modified Date and time stamp of any table? :eek:

Hi, I think I know my way around a database, but my new employer has me doing kart-wheels. There is an Excel sheet of values which I have imported to Access tables, the table contains ledger values on it and the account numbers are in the fields as column headers. I want to reflect those field...