Fed Alexander
asked on
Append Issue
Hello Experts,
I tried to append the data from the excel file to access table and for some reason some o the filed comes blank. however, there is data in the excel file. can I get any help with this?
123456.xlsx
I tried to append the data from the excel file to access table and for some reason some o the filed comes blank. however, there is data in the excel file. can I get any help with this?
123456.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad i provide guidance for others... :)
Glad I put you on the right track :)
ASKER
thank you, it worked
Option 1 : Convert it to .csv and import it back to Access...while strange it seems that it recognizes better the date/time fields
Option 2: Use VBA to connect to Excel and import it line by line so that you have complete control on what and how you handle field data.